Re: Column names

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Mark Muffett <markm(at)muffett(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Column names
Date: 2001-10-19 13:46:52
Message-ID: Pine.LNX.4.30.0110190945430.17960-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 2001-10-19 13:49:23 Re: RPM postmaster -i ?
Previous Message Brett W. McCoy 2001-10-19 13:43:50 Re: Backup Postgre Windows to Linux