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?
Tweet
add to del.icio.usRelated 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
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!
Recent Entries
- Travis CI Error when installing oraclejdk8
- Tuning Tomcat IIS Connectors worker.properties and server.xml
- Push Tomcat logs with the AWS CloudWatch Logs Agent
- Sending nginx access logs to CloudWatch Logs Agent
- Setup CloudWatch Logs Agent on Ubuntu 18.04 LTS
- Tomcat Virtual Directory Howto
- Communications link failure MySQL JDBC with TLS
- Redirect www and non https in IIS using web.config
