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

From Ron Peterson
Subject Re: Is there anything like DESCRIBE?
Date
Msg-id 3A70E240.64FC7006@yellowbank.com
Whole thread Raw
In response to Is there anything like DESCRIBE?  ("Mike D'Agosta" <mdagosta@earthtribe.net>)
List pgsql-sql
Mike D'Agosta wrote:
> 
> 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?

src/tutorial/syscat.source has some examples you might like to study.

-Ron-


pgsql-sql by date:

Previous
From: "Glen and Rosanne Eustace"
Date:
Subject: Re: Problem with Dates
Next
From: Tom Lane
Date:
Subject: Re: Rule not invoked in 7.1