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