Cheat Sheet for PostgreSQL

September 07, 2005
databases

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?



Related Entries

1 person 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?
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
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 postgresqlfr.org 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 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.
Thanks Guillaume!

Post a Comment




  



Spell Checker by Foundeo

Recent Entries



foundeo


did you hack my cf?