PostgreSQL Administrator’s Cheatsheet

Dec 30, 2009 / By Lukas Vysusil

Tags: , ,

Most people start with free databases and eventually get to know the enterprise products. I started the other way around.

After being trapped for eight years in the Oracle world, I felt like exploring another database platform. For some reason I can’t get myself to fiddle around with MySQL. There’s nothing rational about this–no benchmarks, reviews, or co-worker horror stories. I feel it’s just not my type.

So when looking for free database, I reached out for PostgreSQL, again for no objective reason–only the gut feeling that this could be what I’m looking for.

I took advantage of the Christmas holidays to dive into it, and guess what? I like it! That’s why I decided to put together this small cheat sheet of most common things administrators might be looking for. If you are used to Oracle. I added equivalents in red where appropriate for quicker orientation.

By the way, if you ask me what to use for a lightweight web development platform, I made my choice–PHP 5 with the CodeIgniter framework and PostgreSQL 8.4 on Oracle Enterprise Linux 5.

And now, here is my PostgreSQL cheatsheet. Enjoy!

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>