Re: Column names - Mailing list pgsql-general

From Brett W. McCoy
Subject Re: Column names
Date
Msg-id Pine.LNX.4.30.0110190945430.17960-100000@chapelperilous.net
Whole thread Raw
In response to Column names  ("Mark Muffett" <markm@muffett.net>)
Responses Re: Column names  (merlyn@stonehenge.com (Randal L. Schwartz))
List pgsql-general
On Fri, 19 Oct 2001, Mark Muffett wrote:

> Is there a simple query to return the column names used in a table?

If you start up psql with the -E option, and then do \dt <tablename>, it
will spit out the SQL used to retrieve the metadata on your table.  You
can use that as your basis.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
After a number of decimal places, nobody gives a damn.


pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: RPM postmaster -i ?
Next
From: "Brett W. McCoy"
Date:
Subject: Re: Backup Postgre Windows to Linux