From: | Ilan Volow <listboy(at)clarux(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: functions pg_get... |
Date: | 2007-11-15 15:49:35 |
Message-ID: | 9B7D104F-7FDE-4EA2-A5AA-CCEE42DC5C5B@clarux.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I've found the queries at this link to be very good for getting
detailed postgresql schema information (table columns, triggers, etc)
http://www.alberton.info/postgresql_meta_info.html
-- Ilan
On Nov 15, 2007, at 10:33 AM, König, Monika wrote:
> I'm looking for a postgres-funtion that shows me the definition of
> a table.
>
> I found the
> -- pg_catalog.pg_get_viewdef(oid)
> -- pg_catalog.pg_get_constraintdef(oid)
> -- pg_catalog.pg_get_triggerdef(oid)
> -- pg_get_indexdef(oid)
>
>
> but I miss the same for a relation.
>
>
> Monika König
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
Ilan Volow
"Implicit code is inherently evil, and here's the reason why:"
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma Jr | 2007-11-15 16:06:49 | Re: "global/pg_control": Permission denied |
Previous Message | Andrew Sullivan | 2007-11-15 15:39:52 | Re: functions pg_get... |