Respected Sir.
This is srinivas.
I have more enhusiasm to work with Postgresql. Since i have good
exposure on Rdbms packages such as Oracle, Sql Server and so on.
Now my interest is turned to Postgresql.I have created some tables with
constraints. Now i have startd write functions in plpgsql a
while you weren't looking, Chris Hoover wrote:
> That really does not work. It will tell you line by line differences,
> but not what object it is. Also, it does not help to generate the sql
> to sync the db's.
There are graphical diff tools that will show the relationships
between the various
That really does not work. It will tell you line by line differences,
but not what object it is. Also, it does not help to generate the sql
to sync the db's.
Chris
Rosser Schwarz wrote:
while you weren't looking, Chris Hoover wrote:
Does anyone know of any good tools that will compare 2 db's a
Hi again,
Is there any updated info available on latest releases. Or should
I ask elsewhere ;-), like on hackers (I'm not on that list but can subscribe).
If my assumptions forwarded below are generally correct in regards to
current state of things, then simple "yes" will be enough for me
while you weren't looking, Chris Hoover wrote:
> Does anyone know of any good tools that will compare 2 db's and generate a
> complete listing of any object differences?
Perhaps something like:
$ pg_dump --schema-only db1 > db1.sql
$ pg_dump --schema-only db2 > db2.sql
$ diff db1.sql db2.sql
Does anyone know of any good tools that will compare 2 db's and generate a
complete listing of any object differences? I need both the tables, views,
functions, etc. as well as the object permissions.
I have tried EMS's PostgreSQL DB Compare, but it does not provide the
permission comparison.
unsubscribe pgsql-admin
Hi,
Thanks for that. It seems that you were right.
We used pg_restore to create a plain text dump file on the original machine
and brought that down to the other machine which worked fine.
regards
Iain
> Apparently you are trying to load into a server compiled wit
unsubscribe pgsql-admin
