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?

Like this? Follow me ↯

You might also like:

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


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?
Hey Brandon, I'm using the serial datatype in my CREATE TABLE example which is a shortcut datatype for doing auto numbering in postgresql:
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.
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.
This sheet is great. Would you allow me to translate it in french and publish it on the website ? Thanks, Guillaume.
Guillaume, Yes please translate it into french. I just ask that you also link to my english version from that page. Thanks
Thank you, it's done. You can find it on There's a link at the beginning to your english version. Of course, I also kept the copyright notice.
Thanks Guillaume!

Foundeo Inc.