Revisions to How do I list all databases and tables using psql?

added 1 character in body

edited Sep 26, 2023 at 13:02

223
1
8

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS\dtS+ *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

These list all tables of my_schema schema of the current database:

\dtS my_schema.*

\dt my_schema.*

These list all tables of my_schema schema of the current database in detail:

\dtS+ my_schema.*

\dt+ my_schema.*

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

These list all tables of my_schema schema of the current database:

\dtS my_schema.*

\dt my_schema.*

These list all tables of my_schema schema of the current database in detail:

\dtS+ my_schema.*

\dt+ my_schema.*

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS+ *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

These list all tables of my_schema schema of the current database:

\dtS my_schema.*

\dt my_schema.*

These list all tables of my_schema schema of the current database in detail:

\dtS+ my_schema.*

\dt+ my_schema.*

added 312 characters in body

Source Link

edited Sep 24, 2023 at 15:53

Super Kai - Kazuya Ito

223
1
8

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

These list all tables of my_schema schema of the current database:

\dtS my_schema.*

\dt my_schema.*

These list all tables of my_schema schema of the current database in detail:

\dtS+ my_schema.*

\dt+ my_schema.*

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

These list all tables of my_schema schema of the current database:

\dtS my_schema.*

\dt my_schema.*

These list all tables of my_schema schema of the current database in detail:

\dtS+ my_schema.*

\dt+ my_schema.*

added 116 characters in body

Source Link

edited Sep 24, 2023 at 15:34

Super Kai - Kazuya Ito

223
1
8

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

This listsThese list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

This listsThese list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

This lists all tables of pg_catalog and public schemas of the current database:

\dtS

This lists all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

<Database>

This lists all databases:

SELECT datname FROM pg_database;

These list all databases in detail:

\list

\l

These list all databases in more detail:

\list+

\l+

<Table>

These list all tables of all schemas of the current database:

\dt *.*

\dtS *.*

These list all tables of all schemas of the current database in detail:

\dt+ *.*

\dtS *.*

These list all tables of pg_catalog and public schemas of the current database:

\dtS

\dtS *

\dt *

These list all tables of pg_catalog and public schemas of the current database in detail:

\dtS+

\dtS+ *

\dt+ *

This lists all tables of public schema of the current database:

\dt

This lists all tables of public schema of the current database in detail:

\dt+

added 273 characters in body

Source Link

edited Sep 24, 2023 at 2:11

Super Kai - Kazuya Ito

223
1
8

Loading

added 38 characters in body

Source Link

edited Sep 23, 2023 at 20:58

Super Kai - Kazuya Ito

223
1
8

Loading

added 39 characters in body

Source Link

edited Sep 23, 2023 at 20:06

Super Kai - Kazuya Ito

223
1
8

Loading

added 43 characters in body

Source Link

edited Sep 23, 2023 at 19:56

Super Kai - Kazuya Ito

223
1
8

Loading

added 35 characters in body

Source Link

edited Sep 23, 2023 at 4:35

Super Kai - Kazuya Ito

223
1
8

Loading

added 12 characters in body

Source Link

edited Sep 23, 2023 at 4:06

Super Kai - Kazuya Ito

223
1
8

Loading

Source Link

answered Sep 23, 2023 at 4:01

Super Kai - Kazuya Ito

223
1
8

Loading

Stack Exchange Network

Return to Answer

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>

<Database>

<Table>