Nice postgres tips

Questions and answers regarding general SQL and backend databases

Nice postgres tips

Postby Bernd.N » Mon Aug 08, 2016 10:34 pm

For those who are not yet postgres gurus, this link might be interesting with more than 100 postgres tips:
https://til.hashrocket.com/sql

They also have a nice podcast site
https://www.pgcasts.com/
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 487
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Nice postgres tips

Postby marco.rossi » Tue Aug 09, 2016 4:42 pm

Thank you for sharing it
Marco Rossi
Senior Analyst Developer
Freelance Consultant

IT Manager @Mantho
Webmaster @Sitoliquido
marco.rossi
 
Posts: 42
Joined: Sun Apr 12, 2015 9:33 pm

Re: Nice postgres tips

Postby Bernd.N » Wed Aug 10, 2016 4:02 pm

Here is another site, it contains interesting examples for aggregates and recursive SELECTs.
https://pgexercises.com/questions/aggregates/

There is a Show button on left lower site which shows the answers.

Also interesting:
http://postgresguide.com

And here, a trigger is explained quite understandingly:
http://www.tutorialspoint.com/postgresql/postgresql_triggers.htm
Bernd Korthaus
LinkedIn
Servoy 7.4.9 SC postgreSQL 9.4.11 Windows 10 Pro
User avatar
Bernd.N
 
Posts: 487
Joined: Mon Oct 21, 2013 5:57 pm
Location: Langenhorn, North Friesland, Germany

Re: Nice postgres tips

Postby swingman » Wed Aug 10, 2016 9:52 pm

Great stuff. Thanks for sharing!
Christian Batchelor
Certified Servoy Developer
Batchelor Associates Ltd, London, UK
http://www.batchelorassociates.co.uk

http://www.postgresql.org - The world's most advanced open source database.
User avatar
swingman
 
Posts: 1203
Joined: Wed Oct 01, 2003 10:20 am
Location: London

Re: Nice postgres tips

Postby Manolo_Etec » Wed Aug 24, 2016 9:08 am

thanks!!!
Manuel López
Etec Programación SL
[email protected]
http://www.etecsoft.com

Servoy 8.2.2
Windows 10
Yesterday: Java 1.8.0_141-b15
Manolo_Etec
 
Posts: 56
Joined: Fri Sep 12, 2008 3:58 pm


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 3 guests