4,461
edits
Introduction to PostgreSQL for MySQL Users: Difference between revisions
Introduction to PostgreSQL for MySQL Users (view source)
Revision as of 11:55, 29 August 2016
, 29 August 2016→selecting a DB: add listing all tables
add more sections |
→selecting a DB: add listing all tables |
||
| Line 60: | Line 60: | ||
After selecting a DB you can go ahead and execute SQL commands. | After selecting a DB you can go ahead and execute SQL commands. | ||
== listing all tables == | |||
You can list tables in a DB. | |||
MySQL: | |||
<syntaxhighlight lang="mysql"> | |||
mysql> show tables; | |||
</syntaxhighlight> | |||
PostgreSQL: | |||
<syntaxhighlight lang="psql"> | |||
postgres=# \dt | |||
</syntaxhighlight> | |||
== Exiting from DB == | == Exiting from DB == | ||
Ctrl-D should exit from both. | Ctrl-D should exit from both. | ||