Select from information_schema.columns and full outer join it again on the
table and column names, then just look for nulls on either side. You'll need
to alias the left and right views differently. I'm assuming that the dbs are
next to each other in the same installation. Once the base query is wo
As an alternative to the other tools - I've had luck using a simple query
that uses information schema.
> How Can I do to compare two structures of data bases ?
>
> DBA != DBB I need wich functions and wich tables are not equals
>
> thnks
On Feb 24, 2011, at 5:33 AM, manuel antonio ochoa wrote:
> How Can I do to compare two structures of data bases ?
>
> DBA != DBB I need wich functions and wich tables are not equals
>
> thnks
You can try with apgdiff.
http://apgdiff.startnet.biz/
Thanks & Regards,
Vibhor
--
Sent via pgs
W dniu 2011-02-24 01:03, manuel antonio ochoa pisze:
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
I'd advise SQL Power Architect - very handy tool with graphical DB
design capability.
Will compare your databases
:03 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] Compare two Data bases Structure
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to
How Can I do to compare two structures of data bases ?
DBA != DBB I need wich functions and wich tables are not equals
thnks
