PostgreSQL

Tags:
• database

Querying information about the database

Show all schemas

SELECT * FROM pg_namespace;

Show all system tables

SELECT * FROM pg_tables;

Show all databases

SELECT * FROM pg_database;

Using psql

Show all schemas: \dn
Show all tables: \dt
Connect to a different database: \c databasename