Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for a simple resource for getting the hang of Postgres after using MySQL for years. So far I've figured out \l, \d, and \c, but I'm having trouble listing the tables in my MediaWiki installation.

The Postgres documentation is great, but I'm looking for something a bit more succinct. I've become accustomed to using show databases; use database; show tables, so it would be nice to have a quick reference page on the syntax differences between the two.

I haven't found anything yet, any suggestions?

share|improve this question

closed as off topic by ceejayoz, voretaq7, Magellan, Ward, HopelessN00b Nov 26 '12 at 22:09

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

I suggest that you reread the Postgres documentation which as a list of SQL commands. I'm not sure why you don't want to read it. It is an entirely different DBMS than MySQL, so knowing MySQL doesn't mean that you should skip the standard, up-to-date, complete, and detailed documentation that Postgres makes available for free.

share|improve this answer
+1 - Read The Manual! The Postgres team has written excellent documentation, better in fact than many commercial systems. – voretaq7 Dec 8 '11 at 17:06

As MarkM already said, you need to Read (at least the relevant sections of) The Manual. End of story. Game over. Do not pass go, do not collect $200.

In addition to the manual, Google is your friend: A very quick search on "Postgres for MySQL users" came up with this page, and I'm sure there are hundreds more like it out there.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.