Re: Documenting PGSQL database.

On Apr 7, 4:07 pm, rpk(dot)gene(dot)(dot)(dot)(at)gmail(dot)com (RPK) wrote:
> I am using PGSQL 8.2.3 on Windows XP. I want to know whether there is any way
> of documenting the schema of PGSQL database so that I can get a printed copy
> of the same.
> --
> View this message in context:http://www.nabble.com/Documenting-PGSQL-database.-tf3541712.html#a988...
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

Don't know if this helps, but have you tried;

SELECT * FROM INFORMATION_SCHEMA.tables
- or -
SELECT * FROM INFORMATION_SCHEMA.columns

Have added benefit of being and SQL standard so works on MS-SQL too.

Geoff.