Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 836FA2E2D8B for ; Thu, 15 Nov 2007 11:49:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 92540-09 for ; Thu, 15 Nov 2007 11:49:27 -0400 (AST) Received: from outbound-mail-64.bluehost.com (outbound-mail-64.bluehost.com [69.89.21.24]) by postgresql.org (Postfix) with SMTP id 8D9A32E2D6B for ; Thu, 15 Nov 2007 11:49:44 -0400 (AST) Received: (qmail 22885 invoked by uid 0); 15 Nov 2007 15:49:37 -0000 Received: from unknown (HELO box255.bluehost.com) (69.89.31.55) by mailproxy4.bluehost.com with SMTP; 15 Nov 2007 15:49:37 -0000 Received: from [24.75.42.210] (helo=[192.168.100.67]) by box255.bluehost.com with esmtp (Exim 4.68) (envelope-from ) id 1IsgyG-0002cz-OU for pgsql-admin@postgresql.org; Thu, 15 Nov 2007 08:49:37 -0700 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: <1C2329C9430609409808ECF10237287612EA4CC8@mydomain.com> References: <1C2329C9430609409808ECF10237287612EA4CC8@mydomain.com> Content-Type: multipart/alternative; boundary=Apple-Mail-1--61273262 Message-Id: <9B7D104F-7FDE-4EA2-A5AA-CCEE42DC5C5B@clarux.com> From: Ilan Volow Subject: Re: functions pg_get... Date: Thu, 15 Nov 2007 10:49:35 -0500 To: pgsql-admin@postgresql.org X-Mailer: Apple Mail (2.752.2) X-Identified-User: {670:box255.bluehost.com:claruxco:clarux.com} {sentby:bopbeforesmtp 24.75.42.210 authed with clarux.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/146 X-Sequence-Number: 27389 --Apple-Mail-1--61273262 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed I've found the queries at this link to be very good for getting =20 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=F6nig, Monika wrote: > I'm looking for a postgres-funtion that shows me the definition of =20 > 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=F6nig > > > > ---------------------------(end of =20 > broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster Ilan Volow "Implicit code is inherently evil, and here's the reason why:" --Apple-Mail-1--61273262 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 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=F6nig, Monika = wrote:

I'm looking for a = postgres-funtion that shows me the definition of a table.

I found = the=A0
-- 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=F6nig



TIP 2: = Don't 'kill -9' the postmaster

Ilan = Volow
"Implicit code is inherently evil, and here's the reason = why:"


=

= --Apple-Mail-1--61273262--