accessing field properties - Mailing list pgsql-general

From Campbell, Scott
Subject accessing field properties
Date
Msg-id ED7A447524CCD311A9BF009027DC86ED011E39F3@NSEXCH02
Whole thread Raw
List pgsql-general
Hi,

I'm wondering if it is possible to access the properties of an attribute?
i.e. if a given field is a foreign key or primary key, or if it is integer
or varchar, etc.

Is it possible to do this? I know postgres stores all of its informations in
other tables, i.e. pg_tables etc, so is this information available in one of
those tables?

What I'm ultimatly trying to do is grab this information through a web/perl
interface using DBI and use it to construct the webpage.

Thanks
Scott Campbell

pgsql-general by date:

Previous
From: g
Date:
Subject: pg_dumpall problems
Next
From: mikeo
Date:
Subject: Re: bytea question