Re: Getting table metadata

From: Ken Tozier <kentozier(at)comcast(dot)net>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting table metadata
Date: 2005-01-19 06:58:03
Message-ID: 76F06950-69E7-11D9-BE3A-003065F300E2@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael,

> See "Object Identifier Types" in the "Data Types" chapter.
>
> SELECT * FROM pg_attribute WHERE attrelid = 'tablename'::regclass;

Thanks. That worked like a champ!

Ken

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Bishop 2005-01-19 07:28:25 Re: Multiline plpython procedure
Previous Message Bo Lorentsen 2005-01-19 06:50:51 Re: Index optimization ?