Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT) > >On Thu, 26 Apr 2001, V. M. wrote: > > > ok for serials, now i can extract from psql (\

[GENERAL] Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread Joel Burton
On Thu, 26 Apr 2001, V. M. wrote: (moving this conversation back to pgsql-general, followups to there) > perhaps adding t.tgargs to your view enable me to extract parameters > that are the related fields At SCW, we use a naming convention for RI triggers, to allow us to easily extract that, an

Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
read it, but i can determine only the related tables and not the fields of these tables that are related. valter >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issu

[HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
ok for serials, now i can extract from psql (\d tablename). But i'm not able to extract foreign keys from the schema. >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 13:51:26 -0400 (E

[HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread Joel Burton
On Thu, 26 Apr 2001, V. M. wrote: > ok for serials, now i can extract from psql (\d tablename). > > But i'm not able to extract foreign keys from the schema. Yes you can. Read my tutorial on Referential Integrity in the top section at techdocs.postgresql.org. -- Joel Burton <[EMAIL PROTECT