Postgres Pro
Downloads
Home   >   mailing lists

Re: functions pg_get... - Mailing list pgsql-admin

From Ilan Volow
Subject Re: functions pg_get...
Date
Msg-id 9B7D104F-7FDE-4EA2-A5AA-CCEE42DC5C5B@clarux.com
Whole thread Raw
In response to functions pg_get...  ("König, Monika" <monika.koenig@bonn.de>)
List pgsql-admin
Tree view
I've found the queries at this link to be very good for getting detailed postgresql schema information (table columns, triggers, etc)


-- 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:"



pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: functions pg_get...
Next
From: Richard Broersma Jr
Date:
Subject: Re: "global/pg_control": Permission denied