get referential values - Mailing list pgsql-general

From Esmin Gracic
Subject get referential values
Date
Msg-id AANLkTi=3opLTPcHgGu9P6sM7ZiK2tXuam7v7egJHZvK=@mail.gmail.com
Whole thread Raw
Responses Re: get referential values  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-general
Knowing only tablename (schema_name.table_name) how to retrieve foreign keys and related values. (using pg_catalog is preferred). I developing framework for adobe flex (on php and postgresql).
Already figured out how to get primary key, not null columns and column types, but kinda stuck here.
I can post these queries, if someone needs (it would be nice to have these in wiki - where I've seen the query for primary key retrieval).

I need following format:

select .... 'schema_name.table_name'::regclass....

no | fk_name| table_column_name | foreign_table_name | foreign_column_name

no is used for composite foreign keys.

Thanks!

Esmin.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How can I find a schema that a table belong to?
Next
From: tuanhoanganh
Date:
Subject: Re: PostgreSQL 9.0.1 PITR can not copy WAL file