pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedfunctions pg_get...
3+ messages / 3 participants
[nested] [flat]
* functions pg_get...
@ 2007-11-15 15:33 "König, Monika" <monika.koenig@bonn.de>
2007-11-15 15:39 ` Re: functions pg_get... Andrew Sullivan <ajs@crankycanuck.ca>
2007-11-15 15:49 ` Re: functions pg_get... Ilan Volow <listboy@clarux.com>
0 siblings, 2 replies; 3+ messages in thread
From: "König, Monika" @ 2007-11-15 15:33 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: functions pg_get...
2007-11-15 15:33 functions pg_get... "König, Monika" <monika.koenig@bonn.de>
@ 2007-11-15 15:39 ` Andrew Sullivan <ajs@crankycanuck.ca>
1 sibling, 0 replies; 3+ messages in thread
From: Andrew Sullivan @ 2007-11-15 15:39 UTC (permalink / raw)
To: pgsql-admin
On Thu, Nov 15, 2007 at 04:33:34PM +0100, "König, Monika" wrote:
> I'm looking for a postgres-funtion that shows me the definition of a table.
In psql, this is retrieved by \d [tablename]. By running psql -E, you'll be
able to see how it generates that. (No, I'm not going to tell you, because
I think it's good practice :)
A
--
Andrew Sullivan
Old sigs will return after re-constitution of blue smoke
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: functions pg_get...
2007-11-15 15:33 functions pg_get... "König, Monika" <monika.koenig@bonn.de>
@ 2007-11-15 15:49 ` Ilan Volow <listboy@clarux.com>
1 sibling, 0 replies; 3+ messages in thread
From: Ilan Volow @ 2007-11-15 15:49 UTC (permalink / raw)
To: 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:"
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-11-15 15:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-15 15:33 functions pg_get... "König, Monika" <monika.koenig@bonn.de>
2007-11-15 15:39 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-11-15 15:49 ` Ilan Volow <listboy@clarux.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox