20 апр. 2009 г. · From the psql command line interface,. First, choose your database \c database_name. Then, this shows all tables in the current schema: How to list all tables in psql? - database List all tables in postgresql information_schema PostgreSQL query to list all table names? postgresql list and order tables by size Другие результаты с сайта stackoverflow.com

1 февр. 2024 г. · This tutorial shows you various ways to show tables in a specific database using psql and querying pg_catalog schema in PostgreSQL.

15 окт. 2023 г. · You can also use the command \d in psql, instead of \dt , to show all tables, views, sequences, roles, and other database objects. For help on ...

In Postgres, an SQL command: “\dt” and a couple of built-in schemas: pg_catalog and information_schema, are used to list all the tables of a database.

21 окт. 2024 г. · To view all tables in PostgreSQL, use the \dt command in the psql terminal. It will display the list of tables in the current database.