Pete FreitagCheat 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 ↯
Tweet Follow @pfreitagYou might also like:
- 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
- CheatSheet for Apache - October 7, 2005
- SQL to Select a random row from a database table - September 14, 2005
- Faster Inserts with PostgreSQL - August 31, 2005
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!
