From: | Joel Burton <jburton(at)scw(dot)org> |
---|---|
To: | "V(dot) M(dot)" <txian(at)hotmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: unanswered: Schema Issue |
Date: | 2001-04-26 17:51:26 |
Message-ID: | Pine.LNX.4.21.0104261349160.29630-100000@olympus.scw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, 26 Apr 2001, V. M. wrote:
>
> I want to extract tables schema information, i've looked at
> src/bin/psql/describe.c but i cannot determine the datatype
> 'serial' and
> 'references' from pg_*, i understand that triggers are generated for
> serial
> and references, so how i can understand from my perl application the
> full
> schema ?
SERIALs are just integers (int4). They don't use a trigger, but use a
sequence
as a default value.
REFERENCES are not a type of data, but a foreign key/primary key
relationship. There's still a data type (int, text, etc.)
You can derive schema info from the system catalogs. Use psql with -E for
examples, or look in the Developer Manual.
HTH,
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
From | Date | Subject | |
---|---|---|---|
Next Message | V. M. | 2001-04-26 18:04:14 | Re: unanswered: Schema Issue |
Previous Message | mlw | 2001-04-26 17:45:48 | Re: scaling multiple connections |