Thread

1. unanswered: Schema Issue

   V. M. <txian@hotmail.com> — 2001-04-26T14:46:12Z

   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 ?
   
   thanks,
   valter
   
   _________________________________________________________________________
   Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
   
   
   

2. Re: unanswered: Schema Issue

   Joel Burton <jburton@scw.org> — 2001-04-26T17:51:26Z

   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@scw.org>
   Director of Information Systems, Support Center of Washington