[SQL] Is there anything like DESCRIBE?

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 in psql). Postgres doesn't support DESCRIBE... is there any other way to do this? Thanks! Mike

[SQL] Re: Is there anything like DESCRIBE?

"\d " will give you information similar to what you would normally get from a DESCRIBE. Mike ---- -- "Mike D'Agosta" <[EMAIL PROTECTED]> wrote in message 94n93j$2j6j