Cheat Sheet for PostgreSQL

September 07, 2005

When I created my list of cheat sheets for web development last week, I left out PostgreSQL. Frank Reiser, asked why it was left out - and the reason was simply that I couldn't find one.

Being a PostgreSQL fan, I decided to create a cheat sheet for postgresql myself. It prints out in a little over 1.5 pages.

If you have any suggestions please comment below. digg it?

Permalink | Add Comment |

add to del.icio.us | Tags: postgresql, cheatsheets, sql, cheat, sheet

Related Entries

Cheat Sheet Roundup - Over 30 Cheatsheets for developers - September 1, 2005
CFSCRIPT Cheatsheet - May 5, 2008
Cheat Sheet for SQL Server - April 20, 2009
Top 10 Reserved SQL Keywords - October 28, 2008
INFORMATION_SCHEMA Support in MySQL, PostgreSQL - February 18, 2008

2 people found this page useful, what do you think?

Comments

Looks good Pete. You might want to add the creation of an integer sequence and then a create table statement which using a column which references that sequence for auto-numbering?

by Brandon Harper on 09/07/2005 at 8:39:52 PM UTC

Hey Brandon, I'm using the serial datatype in my CREATE TABLE example which is a shortcut datatype for doing auto numbering in postgresql: http://www.postgresql.org/docs/current/static/datatype.html#DATATYPE-SERIAL

by Pete Freitag on 09/08/2005 at 11:24:44 AM UTC

Oh cool, good to know. I've just recently been finally playing with PostgreSQL and all of the examples I've seen use sequences, so I just assumed that was THE way it was done.

by Brandon Harper on 09/08/2005 at 11:42:08 AM UTC

Yeah, that's what serial does behind the scenes it creates the sequences for you. People probably use the more descriptive syntax because that's what pg_dump will show you.

by Pete Freitag on 09/08/2005 at 11:50:10 AM UTC

This sheet is great. Would you allow me to translate it in french and publish it on the postgresqlfr.org website ? Thanks, Guillaume.

by Guillaume Lelarge on 09/09/2005 at 4:21:21 AM UTC

Guillaume, Yes please translate it into french. I just ask that you also link to my english version from that page. Thanks

by Pete Freitag on 09/09/2005 at 8:49:46 AM UTC

Thank you, it's done. You can find it on http://www.postgresqlfr.org/?q=node/368 There's a link at the beginning to your english version. Of course, I also kept the copyright notice.

by Guillaume Lelarge on 09/09/2005 at 10:43:59 AM UTC

Thanks Guillaume!

by Pete Freitag on 09/09/2005 at 11:19:38 AM UTC

Cheat Sheet for PostgreSQL

Related Entries

Comments

Recent Entries