Mads Lie Jensen <mads@xxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
