From: | Chris Bitmead <chris(at)tech(dot)com(dot)au> |
---|---|
To: | Marzullo Laurent <Laurent(dot)Marzullo(at)sema(dot)be> |
Cc: | PGSQL General list <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Prog to generate table structure ... |
Date: | 1999-08-31 23:58:41 |
Message-ID: | 37CC6C31.894DF865@tech.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
You need to look at the system tables. Like pg_class and the other pg_*
tables.
pg_dump will output CREATE statements to re-create the database. I'm not
sure
that's what you want though.
Marzullo Laurent wrote:
>
> Hello,
>
> is there a prog to generate C file describing table structure
> of a database.
>
> (Something like dclgen under Ingres...)
>
> If not, I would like to know how to get information about
> type of each row of a table to write this kind of prog.
> (i.e. Where is this explain ?)
>
> --
> +----------------------------------+
> | Marzullo Laurent |
> | Analyste-programmeur |
> | SEMA-GROUP Belgium S.A. |
> | Tél: (32) 2 333 52 43 |
> | e-mail: Laurent(dot)Marzullo(at)sema(dot)be |
> +----------------------------------+
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Cimpoesu | 1999-09-01 00:00:05 | Re: [GENERAL] How to display user-defined functions? |
Previous Message | Teodor Cimpoesu | 1999-08-31 23:56:31 | Re: [GENERAL] change null to "" |