Hi
I have this:
SELECT pg_catalog.pg_get_constraintdef(r.oid, true) AS condef
FROM pg_catalog.pg_constraint r,
pg_catalog.pg_class c
WHERE c.oid=r.conrelid
AND r.contype = 'f'
AND c.relname = 'table_name'
which gives me the foreign keys of a given table in the database.
It is working perfectly on my 8.4.2-version of pstgresql.
But what other versions of postgresql will it run on?
Its used in a php-project, and I would like to know which minimum
version of postgres I should recommend.
Thanks in advance.
--
Mads Lie Jensen - mads(at)gartneriet(dot)dk - ICQ #25478403
Gartneriet - http://www.gartneriet.dk/