Re: System catalogues - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: System catalogues
Date
Msg-id Pine.LNX.4.30.0104301815140.900-100000@peter.localdomain
Whole thread Raw
In response to System catalogues  (Zak McGregor <zak@mighty.co.za>)
List 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@gmx.net   http://funkturm.homeip.net/~peter


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL Server -> Postgres migration: Stored Procedure replacement?
Next
From: Tom Lane
Date:
Subject: Re: Help, I dropped a system datatype, and now I'm ....