> 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