PostgreSQL show databases, show tables, describe table operations

[SQL] View PlainCopy

1. 1, quite with the MySQL show databases;

[SQL] View PlainCopy

1. Select Datname from pg_database;

[SQL] View PlainCopy

1. 2, equivalent to the MySQL show tables;

[SQL] View PlainCopy

1. SELECT table_name from information_schema.tables WHERE table_schema = ' public ';

Public is the name of the default schema

[SQL] View PlainCopy

1. 3, quite with the MySQL describe table_name;

[SQL] View PlainCopy

1. SELECT column_name from information_schema.columns WHERE table_name =' table_name ';

[SQL] View PlainCopy

1. ' table_name ' is the name of the table to be queried