Re: Help with creating Documentation - Mailing list pgsql-novice

From joseph speigle
Subject Re: Help with creating Documentation
Date
Msg-id 20070309023157.GA3365@www.sirfsup.com
Whole thread Raw
In response to Help with creating Documentation  (WejofOST@aol.com)
Responses Re: Help with creating Documentation  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-novice
> 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

--
joe speigle
www.sirfsup.com

pgsql-novice by date:

Previous
From: joseph speigle
Date:
Subject: Re: Runaway Instances of Postmaster
Next
From: " Jaromír Kamler"
Date:
Subject: PostgreSQL and import/export to dbf and mdb