Re: database field list - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: database field list
Date
Msg-id irucqi$9h3$1@dough.gmane.org
Whole thread Raw
In response to database field list  (Seb <spluque@gmail.com>)
List pgsql-general
Seb wrote on 29.05.2011 23:04:
> Hi,
>
> I've been scouring the system tables for a way to return a list of
> fields across all tables of a database.  I see that pg_attribute is the
> one to query here, but I'm not sure how to rule out system fields.
> Thanks in advance for any pointers.
>

information_schema.columns is probably easier to look at:

http://www.postgresql.org/docs/current/static/infoschema-columns.html

Thomas

pgsql-general by date:

Previous
From: Seb
Date:
Subject: database field list
Next
From: Alban Hertroys
Date:
Subject: Re: How to check a table content efficiently? With LIMIT and OFFSET?