[GENERAL] database field list

2011-05-29 Thread Seb
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. Cheers, -- Seb -- Sent via pgsql-general

Re: [GENERAL] database field list

2011-05-29 Thread Thomas Kellerer
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.

Re: [GENERAL] database field list

2011-05-29 Thread Seb
On Sun, 29 May 2011 23:11:50 +0200, Thomas Kellerer spam_ea...@gmx.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