PostgreSQL psql How to run Show Tables
POSTGRESQL psql How to run Show Tables
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