pf » Cheat Sheet for PostgreSQL
Cheat Sheet for PostgreSQL
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?
Need Help With SQL?
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
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
People probably use the more descriptive syntax because that's what pg_dump will show you.
Thanks, Guillaume.
Thanks
There's a link at the beginning to your english version. Of course, I also kept the copyright notice.
- ColdFusion 8 FCKeditor Vulnerability
- Ajax Same Origin Policy No More with Firefox 3.5
- Firefox 3.5 Introduces Origin Header, Security Features
- Tips for Secure File Uploads with ColdFusion
- 7 Years And Blog Entry Number 700
- CFCatch Java Exceptions
- Cheat Sheet for SQL Server
- CFML on Google App Engine for Java
RSS
add to del.icio.us
Pete Freitag is a software engineer, and web developer located in











