Re: database field list

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: database field list
Date: 2011-05-29 21:11:50
Message-ID: irucqi$9h3$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-05-29 21:12:53 Re: How to check a table content efficiently? With LIMIT and OFFSET?
Previous Message Seb 2011-05-29 21:04:26 database field list