3 сент. 2014 г. · SHOW TABLES and DESCRIBE TABLE are MySQL-specific admin commands, and nothing to do with standard SQL. You want the: \d. and \d+ tablename. PostgreSQL "DESCRIBE TABLE" - database - Stack Overflow How do I discover the structure of a PostgreSQL database? Другие результаты с сайта stackoverflow.com

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

31 мар. 2023 г. · In PostgreSQL, the “\d”, the “\d+”, “information_schema”, and the “SELECT *” statement with the “FALSE” option are used to check the table's ...

13 авг. 2012 г. · SELECT * FROM information_schema.columns WHERE table_schema = 'your_schema' AND table_name = 'your_table' ;.

By using the psql meta-commands, querying information_schema, or utilizing pg_catalog, you can obtain detailed information about your tables.

13 авг. 2024 г. · Learn how to describe tables in PostgreSQL using psql commands and the information_schema catalog to get detailed column information ...

Оценка 4,6 (146) · От 0,00 $ до 229,00 $ · Инструменты разработки The DESCRIBE statement returns a complete description of the columns of the table, including data types, nullability, primary key constraints, and default ...

9 окт. 2023 г. · 1. Create a database in the PostgreSQL server · 2. Postgres: Show tables in a database · 3. PostgreSQL: Create a table using the 'LIKE' option · 4.

20 нояб. 2024 г. · The \d command in PostgreSQL's interactive terminal, psql, displays information about tables, including column names, data types, and other details.

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