pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed[Fwd: Quick Question Please]
3+ messages / 2 participants
[nested] [flat]
* [Fwd: Quick Question Please]
@ 2003-12-18 20:48 Terry Hampton <thampton@limacorp.com>
0 siblings, 1 reply; 3+ messages in thread
From: Terry Hampton @ 2003-12-18 20:48 UTC (permalink / raw)
To: pgsql-admin
OOPS! This group is quick and sharp.
I was not specific enough with my need.
Sorry to clog your email.
Was is the SQL syntax to
return table names programatically ?
thanks again for a quick hand,
Terry
-------- Original Message --------
Subject: [ADMIN] Quick Question Please
Date: Thu, 18 Dec 2003 15:30:41 -0500
From: Terry Hampton <thampton@limacorp.com>
To: pgsql-admin@postgresql.org
All,
Seem to be having a brain lock.
What is the method or syntax to return
a list of column names for a given table name ?
many thanks for your quick help,
Terry
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [Fwd: Quick Question Please]
@ 2003-12-18 21:21 Bruno Wolff III <bruno@wolff.to>
parent: Terry Hampton <thampton@limacorp.com>
0 siblings, 1 reply; 3+ messages in thread
From: Bruno Wolff III @ 2003-12-18 21:21 UTC (permalink / raw)
To: Terry Hampton <thampton@limacorp.com>; +Cc: pgsql-admin
On Thu, Dec 18, 2003 at 15:48:14 -0500,
Terry Hampton <thampton@limacorp.com> wrote:
>
>
> OOPS! This group is quick and sharp.
> I was not specific enough with my need.
> Sorry to clog your email.
>
> Was is the SQL syntax to
> return table names programatically ?
>
> thanks again for a quick hand,
> Terry
If you run psql with the -E option and then do a \d tablename, the sql
used to calculate the response will be displayed. That sql would be the
right way to do what you want.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [Fwd: Quick Question Please]
@ 2003-12-18 21:47 Terry Hampton <thampton@limacorp.com>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 3+ messages in thread
From: Terry Hampton @ 2003-12-18 21:47 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: pgsql-admin
Bruno,
Excellent advise !
thanks to all,
terry
Bruno Wolff III wrote:
> On Thu, Dec 18, 2003 at 15:48:14 -0500,
> Terry Hampton <thampton@limacorp.com> wrote:
>
>>
>> OOPS! This group is quick and sharp.
>> I was not specific enough with my need.
>> Sorry to clog your email.
>>
>> What is the SQL syntax to
>> return table names programatically ?
>>
>> thanks again for a quick hand,
>> Terry
>
>
> If you run psql with the -E option and then do a \d tablename, the sql
> used to calculate the response will be displayed. That sql would be the
> right way to do what you want.
>
>
--
Terry L. Hampton
Program Manager
LimaCorp, LLC. www.limacorp.com
513.587.1874
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-12-18 21:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-12-18 20:48 [Fwd: Quick Question Please] Terry Hampton <thampton@limacorp.com>
2003-12-18 21:21 ` Bruno Wolff III <bruno@wolff.to>
2003-12-18 21:47 ` Terry Hampton <thampton@limacorp.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox