On Sun, 29 May 2011 23:11:50 +0200, Thomas Kellerer <spam_eater@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
