Re: Help with creating Documentation

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Help with creating Documentation
Date: 2007-03-09 14:45:50
Message-ID: 20070309144550.GA23704@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Garland 2007-03-09 14:46:33 System Log
Previous Message Milen A. Radev 2007-03-09 14:42:42 Re: Pg_dump and bytaA