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
don't know about any facilities to generate C files describing table
structure.
As to obtaining that information, I would say it is all in system catalog
tables (i.e. the tables that start with pg_ and which can be listed with
\dS in psql).
These are the tables that are queried when you use such
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 ?)
--
+---
