[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Which version will this run on?
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2010-01-31 21:11:46
Message-ID: 16400.1264972306 () sss ! pgh ! pa ! us
[Download RAW message or body]

Mads Lie Jensen <mads@gartneriet.dk> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]