Thursday, 17 July 2014

MySQL and Postgres command equivalents

Task: list existing databases, connect to one of the databases, then list existing tables and finally show the structure of one of the tables.

In Mysql:
show databases;
use database;
show tables;
describe table;
In PostgreSQL:
\c database
\d+ table

Possibly Related Posts

No comments:

Post a Comment