System catalogs should help, unless I misunderstand your question: http://www.postgresql.org/docs/9.4/static/catalogs.html http://www.postgresql.org/docs/9.4/static/view-pg-tables.html http://stackoverflow.com/questions/20698169/how-to-use-postgres-pg-tables-to-compare-contraints
On Tue, May 5, 2015 at 1:13 PM, Suresh Raja <suresh.raja...@gmail.com> wrote: > Hi All: > > > I have tables with different versions in the same schema. Like > T1a, T1b, T1c > T2a, T2b, T2c, T2d > .... > ... > etc. > > > I'm interested in documenting various version of tables, may be in excel > sheet or may be in another schema in the database. I would like to store > information on table name, column names, column order, pry key column etc. > Also is there a way I can reverse engineer from the database itself. > > Let me know if anybody any suggestion or format that they used. I > appreciate all your help and shall be suitably acknowledged. > > Thanks, > -Suresh Raja > >
