Обсуждение: [Fwd: Quick Question Please]
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
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.
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