Re: functions pg_get...

[Ilan Volow <listboy@xxxxxxxxxx>]

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