Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting table metadata - Mailing list pgsql-general

From Ken Tozier
Subject Re: Getting table metadata
Date
Msg-id 76F06950-69E7-11D9-BE3A-003065F300E2@comcast.net
Whole thread Raw
In response to Re: Getting table metadata  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: update in triggers
Next
From: Stuart Bishop
Date:
Subject: Re: Multiline plpython procedure