Re: query on table name to return columns and data types?

From: Erik Jones <erik(at)myemma(dot)com>
To: blackwater dev <blackwaterdev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: query on table name to return columns and data types?
Date: 2006-12-15 18:11:31
Message-ID: 4582E553.80603@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

blackwater dev wrote:
> How can I run a query based on a table name and get the column names
> and data types returned?
>
> Thanks!
Check out the columns view in the information_schema.

--
erik jones <erik(at)myemma(dot)com>
software development
emma(r)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Khavkine 2006-12-15 18:54:06 FreeBSD shared memory settings
Previous Message Joshua D. Drake 2006-12-15 17:42:20 Re: query on table name to return columns and data types?