-7

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?

5ba8cabe450348c7fbe2
  • 1

2 Answers2

1

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.

MDMarra
  • 100,183
  • 32
  • 195
  • 326
  • +1 - Read The Manual! The Postgres team has written excellent documentation, better in fact than many commercial systems. – voretaq7 Dec 08 '11 at 17:06
0

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.

voretaq7
  • 79,345
  • 17
  • 128
  • 213