Skip site navigation (1) Skip section navigation (2)

Re: database field list

From: Seb <spluque(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: database field list
Date: 2011-05-29 21:27:13
Message-ID: 8739jx9ozy.fsf@kolob.subpolar.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-general
On Sun, 29 May 2011 23:11:50 +0200,
Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> 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

This is perfect!

Thanks,

-- 
Seb


In response to

pgsql-general by date

Next:From: Stefan KellerDate: 2011-05-29 21:55:01
Subject: Re: How to check a table content efficiently? With LIMIT and OFFSET?
Previous:From: Alban HertroysDate: 2011-05-29 21:12:53
Subject: Re: How to check a table content efficiently? With LIMIT and OFFSET?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group