How do you perform the equivalent of Oracle's DESCRIBE TABLE
in PostgreSQL (using the psql command)?
PostgreSQL “DESCRIBE TABLE”
postgresqlpsqltable-structure
Related Topic
- Postgresql – Insert, on duplicate update in PostgreSQL
- Sql – Save PL/pgSQL output from PostgreSQL to a CSV file
- Postgresql – How to drop all the tables in a PostgreSQL database
- Postgresql – How to start PostgreSQL server on Mac OS X
- Postgresql – How to exit from PostgreSQL command line utility: psql
- Postgresql – Run a PostgreSQL .sql file using command line arguments
- Postgresql – How to change PostgreSQL user password
- Postgresql – psql: FATAL: database “
” does not exist
Best Answer
Try this (in the
psql
command-line tool):See the manual for more info.