Mike D'Agosta wrote:
> 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.
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2001-01-26 03:35:46|
|Subject: Re: Rule not invoked in 7.1 |
|Previous:||From: Ron Sofrin||Date: 2001-01-25 23:47:47|
|Subject: SQL function and composite types|