Mads Lie Jensen <[email protected]> writes:
> 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?
A quick test says that it works back to 7.4, which is the oldest
version that is supported at all anymore. I don't think you need
to worry too much.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
