[Fwd: Quick Question Please]

[Terry Hampton]

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 <***@limacorp.com>
To: pgsql-***@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



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Bruno Wolff III]

On Thu, Dec 18, 2003 at 15:48:14 -0500,

Post by Terry Hampton
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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Terry Hampton]

Bruno,

Excellent advise !

thanks to all,
terry

Post by Bruno Wolff III
On Thu, Dec 18, 2003 at 15:48:14 -0500,

Post by Terry Hampton
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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings