PostGIS in Action
About the Authors
Consulting
Saturday, January 05. 2008PostgreSQL 8.3 Cheat Sheet OverviewPrinter FriendlyBelow is a Thumbnail view of a PostgreSQL 8.3 Cheat Sheet that covers prior PostgreSQL constructs plus new 8.3 features. PDF version of this cheat sheet is available at PostgreSQL 8.3 Cheat sheet in PDF 8/12 by 11", PostgreSQL 8.3 Cheat sheet in PDF A4 and the PostgreSQL 8.3 Cheat sheet in HTML. 
We apologize for the small size of the fonts. We tried to keep it to a minimum but had trouble deciding what to leave out to keep it to a one page sheet. So perhaps it would have been better as a 2 part cheatsheet. Anyrate we hope people find it useful. For people who love cheat sheets, here are two other PostgreSQL cheat sheets on the web which we have found useful and cover slightly different set of things than we do in ours.
Comments
Display comments as
(Linear | Threaded)
Your "DML examples" are "DDL examples".
(and your comment functionality gives a quite verbose error if cookies are disabled)
You should think about making that cheatsheet image a PNG rather than a JPG. The fonts are small enough that JPG can't really handle it without the compression mangling the characters. It takes an effort to read some of that JPG.
We've added an A4 version. Unfortunately we don't have any A4 paper to verify if it prints out right. Let us know how that works out.
It's pretty good. If you could centre it that would be even better but I really am nit picking :-)
Anyway thanks for doing that I now have a copy pinned on the wall next to my desk.
I'd like to see a two-page version. That way you could include more info, or make the fonts bigger to assist aging eyes (like mine). But best is that I can then print two pages and place them back-to-back in a plastic sleeve. It's much easier to manipulate with one hand than it is holding two sheets and I don't need duplex printing.
You are not alone in that complaint. We'll try to provide a 2-pager later on. Perhaps having the samples on a separate page and using the rest of the space to stretch out the options. Not sure which layout would work best.
very helpful for sql developers and learners alike. Thanks.
|
Entry's LinksQuicksearchCalendar
Categories
SubscribeBlog Administration |
|||||||||||||||||||||||||||||||||||||||||||||||||
PostgreSQL 8.3 Cheat Sheet Overview - Postgres OnLine Journal
Tracked: Jan 06, 19:15
What is TSearch? TSearch is a Full-Text Search engine that is packaged with PostgreSQL. The key developers of TSearch are Oleg Bartunov and Teodor Sigaev who have also done extensive work with GiST and GIN indexes used by PostGIS, PgSphere and other pro
Tracked: Feb 29, 12:22
Tracked: Oct 20, 13:16