| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Markus Wagner <wagner(at)imsd(dot)uni-mainz(dot)de> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: audit trail and system catalogs |
| Date: | 2001-06-06 16:23:15 |
| Message-ID: | Pine.BSF.4.21.0106060912530.15715-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 6 Jun 2001, Markus Wagner wrote:
> The problem is, how to get the names of all tables and their attributes? I
> looked into the system tables ("pg_*"), but there were many tables and
> many attributes for *my* tables, and I did not figure out how to
> distinguish my tables and my attributes from the other ones. None of the
> columns in pg_class and pg_attribute seems to give information on wether
> the item is system or user defined.
IIRC, attnum<0 means it's a system column. So you only want the ones with
positive attnum values.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | george young | 2001-06-06 16:24:06 | Memory exhausted in AllocSetAlloc |
| Previous Message | Stephan Szabo | 2001-06-06 15:54:17 | Re: [SQL] Foreign Keys and Inheritance |