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?
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
Trackbacks
Trackback Address: 460/C60519DBA623F581B6448F39C45053D1
Comments
On 09/07/2005 at 10:39:52 PM EDT Brandon Harper wrote:
1
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?
On 09/08/2005 at 1:24:44 PM EDT Pete Freitag wrote:
2
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
On 09/08/2005 at 1:42:08 PM EDT Brandon Harper wrote:
3
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.
On 09/08/2005 at 1:50:10 PM EDT Pete Freitag wrote:
4
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.
On 09/09/2005 at 6:21:21 AM EDT Guillaume Lelarge wrote:
5
This sheet is great. Would you allow me to translate it in french and publish it on the postgresqlfr.org website ?
Thanks, Guillaume.
On 09/09/2005 at 10:49:46 AM EDT Pete Freitag wrote:
6
Guillaume, Yes please translate it into french. I just ask that you also link to my english version from that page.
Thanks
On 09/09/2005 at 12:43:59 PM EDT Guillaume Lelarge wrote:
7
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.
On 09/09/2005 at 1:19:38 PM EDT Pete Freitag wrote:
8
Thanks Guillaume!
Post a Comment
Recent Entries
- Howto Install and Run the Android Emulator
- jQuery UI Autocomple IE 6 Select List z-Index Issues
- Path Traversal Vulnerability Security Hotfix for ColdFusion Released
- Using AntiSamy with ColdFusion
- Writing Secure CFML Slides from CFUnited 2010
- Locking Down ColdFusion Presentation Slides
- Cross Domain Data Theft using CSS
- Using jQuery UI Autocomplete with Hidden ID's
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.
