Обсуждение: [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