Show databases, show tables, and describe table operations in postgresql, and describetable

Show databases, show tables, and describe table operations in postgresql, and describetable

1. It is equivalent to the show databases of mysql;

Select datname from pg_database;

2. It is equivalent to the show tables of mysql;

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public ';

Public is the name of the default schema.

3. Similar to mysql's describe table_name;

SELECT column_name FROM information_schema.columns WHERE table_name = 'table _ name ';

'Table _ name' is the name of the table to be queried.

What are the SQL statements used to display all databases? I know that mysql can use show databases; to display the show tables Table;

Select * from sysdatabases
Or execute the system stored procedure
Sp_helpdb

Comparison between PostgreSQL and Mysql

Mysql: show databases
Pgsql: \ l or \ l + (more information is displayed)

Mysql: use xx
Pgsql: \ c xx

Mysql: show tables
Pgsql: \ dt