Re: functions pg_get...

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