filmov
tv
PostgreSQL psql How to Create Database, List, Show and Drop

Показать описание
POSTGRESQL psql How to Create Database, List, Show and Drop
# CREATE DATABASE testdb;
* list all dbs
# \l
# \l testdb
* change database, connect to new database
# \c testdb;
# \connect testdb
* list all tables
# \d
* describe all tables
# \d table_name
# \d+ table_name
* quit
# \q
# CREATE DATABASE testdb;
* list all dbs
# \l
# \l testdb
* change database, connect to new database
# \c testdb;
# \connect testdb
* list all tables
# \d
* describe all tables
# \d table_name
# \d+ table_name
* quit
# \q