Re: Help with creating Documentation

On Fri, Mar 09, 2007 at 11:31:57 +0900,
joseph speigle <joesp(at)sirfsup(dot)com> wrote:
> > I have inherited a pgsql database and a raft of PHP programs.
> > I am a "novice" as far as pgsql is concerned although as a mainframe
> > dinosaur I have knowledge of a number of RDBS systems plus MS-SQL and MySQL .
> > The PHP code is quite readable but on the database side the previous owner
> > did not believe in documentation!
> >
> > How can I generate a list of tables and then fields within the tables in
> > pgsql?
> >
>
> maybe you just want to dump all the DDL at one time
> @localhost] pg_dump db_name > db_name.txt

You probably want to use the -s so you only get the DDL.

You can also read up on the information schema and the catalogs, if you
want to make queries to look for specific things.