23 окт. 2015 г.

mysql <-> postgresql cli

  • $ mysql -u root -prootpassword
$ su - postgres
$ psql
  • mysql> show databases;
postgres=# \l
  • mysql> use mybase;
postgres=# \c mybase
  • mysql> show tables;
ocdp=# \dt
  • mysql> create database mybase;
postgres=# create database mybase;
  • mysql> drop database mybase;
postgres=# drop database mybase;
  • mysql> quit
postgres=# \q