Postgres Pro
Downloads
Home   >   mailing lists

Is there anything like DESCRIBE? - Mailing list pgsql-sql

From Mike D'Agosta
Subject Is there anything like DESCRIBE?
Date
Msg-id 94n93j$2j6j$1@news.tht.net
Whole thread Raw
Responses Re: Is there anything like DESCRIBE?  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-sql
Tree view 
Hi,
  I have a number of empty tables and I want to get the column names and
data types with an SQL statement. I want to do this procedurally, not
interactively (so I can't use \d <tablename> in psql). Postgres doesn't
support DESCRIBE... is there any other way to do this?

Thanks!
Mike

pgsql-sql by date:

Previous
From: David Olbersen
Date:
Subject: Don't want blank data
Next
From: Ian Harding
Date:
Subject: Re: #DELETED error when using Access 2000 as frontend