How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?
DESCRIBE TABLE
Try this (in the psql command-line tool):
psql
\d+ tablename
See the manual for more info.
I have some .sql files with thousands of INSERT statements in them and need to run these inserts on my PostgreSQL database in order to add them to a table. The files are that large that it is impossible to …
In MySQL, I used use database_name; What's the psql equivalent?
What command or short key can I use to exit the PostgreSQL command line utility psql?
