Is there anything like DESCRIBE?

From: "Mike D'Agosta" <mdagosta(at)earthtribe(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Is there anything like DESCRIBE?
Date: 2001-01-24 19:00:33
Message-ID: 94n93j$2j6j$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David Olbersen 2001-01-24 19:31:57 Please don't kill me!
Previous Message Jie Liang 2001-01-24 18:12:36 Re: How to change the ownership of the table?