Introduction to PostgreSQL for MySQL Users: Difference between revisions

Jump to navigation Jump to search
→‎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.

Navigation menu