Sample Header Ad - 728x90

List all columns for a specified table

577 votes
5 answers
1296393 views
I'm looking for a precise piece of information in a database which I have no knowledge about. The database is on a separate machine, but I can log into it, and launch a psql command line, with administrator rights. It's a third-party product, and they are slow to answer questions. I know the data is inside that database, so I want to do a little bit of reverse-engineering. Given a table name, is it possible to get a list of the names of the columns in that table? For example, in SQL Server, it's possible to dump a table into a reusable CREATE statement, which textually lists all the columns the table is composed of.
Asked by Stephane Rolland (8911 rep)
Aug 13, 2012, 12:44 PM
Last activity: May 23, 2021, 01:42 PM