On Apr 7, 4:07 pm, rpk.gene...@xxxxxxxxx (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.
