26 мар. 2013 г. · You can select the tables from information_schema. SELECT * FROM information_schema.tables WHERE table_schema = 'public'. Show table structure and list of tables in PostgreSQL [duplicate] How do I discover the structure of a PostgreSQL database? Другие результаты с сайта stackoverflow.com

14 апр. 2020 г. · To show all tables, SELECT * FROM pg_catalog.pg_tables; To show only tables from a specific schema, use WHERE function as it follows:

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 ...

1 февр. 2024 г. · In this tutorial, you will learn how to use the psql tool and information_schema to describe tables in PostgreSQL.