From: | merlyn(at)stonehenge(dot)com (Randal L(dot) Schwartz) |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
Cc: | Mark Muffett <markm(at)muffett(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Column names |
Date: | 2001-10-19 18:57:23 |
Message-ID: | m1r8rz1mr0.fsf@halfdome.holdit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>>>>> "Brett" == Brett W McCoy <bmccoy(at)chapelperilous(dot)net> writes:
Brett> On Fri, 19 Oct 2001, Mark Muffett wrote:
>> Is there a simple query to return the column names used in a table?
Brett> If you start up psql with the -E option, and then do \dt <tablename>, it
Brett> will spit out the SQL used to retrieve the metadata on your table. You
Brett> can use that as your basis.
A little birdy whispered in my ear that my request to push all the SQL
that psql uses into views so they'd be trivially query-able and
stackable has been put on the official TO-DO list.
So, maybe in 7.2? :)
--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn(at)stonehenge(dot)com> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!
From | Date | Subject | |
---|---|---|---|
Next Message | Herbert.Liechti | 2001-10-19 19:10:12 | Bug in pg_dump/pg_restore |
Previous Message | Mihai Gheorghiu | 2001-10-19 18:56:31 | Upgrade |