From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Zak McGregor <zak(at)mighty(dot)co(dot)za> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: System catalogues |
Date: | 2001-04-30 16:16:23 |
Message-ID: | Pine.LNX.4.30.0104301815140.900-100000@peter.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Zak McGregor writes:
> for eg:
> SELECT distinct a.attname FROM pg_class c, pg_attribute a, pg_type t WHERE
> c.relkind = 'r' and c.relname = 'example' and a.attnum > 0 and
> a.attrelid = c.oid and a.atttypid = t.oid ORDER BY attname
>
> but where 'example' is a table in another database, not the admin
> database. What I would like to do is a join on my admin metadata with the
> data in pg_attribute to see where I have no metadata on the field in
> question in the admin database. I hope that makes sense!
This seems like the right idea, but you can't make queries that span more
than one database.
> Is this possible? Has anyone written any sort of documentation on the
> system catalogues that I might be able to read?
In the Developer's Guide on the web site or in your local installation.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-30 16:23:30 | Re: Help, I dropped a system datatype, and now I'm .... |
Previous Message | Randall Perry | 2001-04-30 15:52:06 | PHPPgAdmin or MS Access |