perhaps adding t.tgargs to your view enable me to extract parameters
that are the related fields
---------------------------------------
CREATE VIEW dev_ri
AS
SELECT ***** t.tgargs **** , t.oid as trigoid,
c.relname as trig_tbl,
t.tgfoid,
f.proname as trigfunc,
t.tgenabled,
t.tgconstrname,
c2.relname as const_tbl,
t.tgdeferrable,
t.tginitdeferred
FROM pg_trigger t,
pg_class c,
pg_class c2,
pg_proc f
WHERE t.tgrelid=c.oid
AND t.tgconstrrelid=c2.oid
AND tgfoid=f.oid
AND tgname ~ '^RI_'
ORDER BY t.oid;
a tgargs example is:
fk_provincie_id_paesi_id_provin\000paesi\000province\000UNSPECIFIED\000id_provincia\000id\000
first field (fk_provincie_id_paesi_id_provin) is constraint name, and i can
understand that: paesi(id_provincia) references provincia(id).
valter
>From: Joel Burton <[EMAIL 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 (\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 PROTECTED]>
>Director of Information Systems, Support Center of Washington
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
