Nicholas,
To use the dblink:
1. In your postgres server you should find a file *dblink.sql*.
In my beta installation is in *share/postgresql/contrib*. It is the
installation for the dblink contrib module that usually is already compiled
in. It will create a lot of dblink functions.
i've not tried this in postgres, but using information_schema makes
comparing structures of databases trivial. i've been using this query for a
while with MSSQL. Maybe this helps to answer the question.
- isaac
select ST.Table_Name, ST.Column_Name, DV.Table_Name, DV.Column_Name, *
from
2009/5/2 Isaac Dover isaacdo...@gmail.com
i've not tried this in postgres, but using information_schema makes
comparing structures of databases trivial. i've been using this query for a
while with MSSQL. Maybe this helps to answer the question.
- isaac
select ST.Table_Name, ST.Column_Name,
Thank you, Lucas. I'm from the MS world, still learning these PG things.
Though, it appears that the difference is somewhat minor. In my actual
implementation, [other database] would be a linked server, which sounds like
it would be similar to the PG dblink. Regardless, I've found information
; Pawel Socha; pgsql-sql@postgresql.org
*Subject:* Re: [SQL] Comparing two tables of different database
Hi All,
For example,
There are two database. database1 and database 2;
database1 has a table called pr_1 with the columns, id,name and time.
database2 has a table called
On 05/01/2009 11:55 AM, John Zhang wrote:
Hi Nicholas,
The query is across database query. dblink is needed for that task.
Hope it helps,
John
On Thu, Apr 30, 2009 at 3:07 PM, Edward W. Rouse
ero...@comsquared.com mailto:ero...@comsquared.com wrote:
Can’t you use this?
select
On 2009-04-29, Nicholas I nicholas.domni...@gmail.com wrote:
--000e0cd1d5062f2ca40468abd813
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi,
can anybody me suggest me, how to compare two tables of different
database.
you probably want to use some sort of
Hi All,
For example,
There are two database. database1 and database 2;
database1 has a table called pr_1 with the columns, id,name and time.
database2 has a table called sr_1 with the_columns id,name and time.
i would like to find out the differences that is, find the
2009/4/29 Nicholas I nicholas.domni...@gmail.com:
can anybody me suggest me, how to compare two tables of different
database.
Two PostgreSQL databases: dblink
http://www.postgresql.org/docs/current/interactive/dblink.html
Distinct DBMS: dbilink
http://pgfoundry.org/projects/dbi-link/
On Thu, Apr 30, 2009 at 08:20:02AM +1000, Adam Ruth wrote:
The simple answer is to pg_dump both tables and compare the output with
diff.
Other than that, I think you'll need a custom program.
For all but the strictest definition of identical, that won't work.
Tables may easily contain
]
On Behalf Of Nicholas I
Sent: Thursday, April 30, 2009 6:12 AM
To: Joshua Tolley
Cc: Adam Ruth; Pawel Socha; pgsql-sql@postgresql.org
Subject: Re: [SQL] Comparing two tables of different database
Hi All,
For example,
There are two database. database1 and database 2;
database1 has
On 2009-04-29, Nicholas I nicholas.domni...@gmail.com wrote:
--000e0cd1d5062f2ca40468abd813
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Hi,
can anybody me suggest me, how to compare two tables of different
database.
you want to use a join but can't...
Hi,
can anybody me suggest me, how to compare two tables of different
database.
-Nicholas I
2009/4/29 Nicholas I nicholas.domni...@gmail.com:
Hi,
can anybody me suggest me, how to compare two tables of different
database.
-Nicholas I
what you mean 'different database' :)
diffrent version, 2 instance ?
Maybe this help:
http://www.postgresql.org/docs/current/static/dblink.html
Nicholas I, 29.04.2009 08:39:
Hi,
can anybody me suggest me, how to compare two tables of different
database.
Do you want to compare the data or the structure of the two tables?
Thomas
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
Hello
try to look on http://pgfoundry.org/forum/forum.php?forum_id=1392
regards
Pavel Stehule
2009/4/29 Nicholas I nicholas.domni...@gmail.com:
Hi,
can anybody me suggest me, how to compare two tables of different
database.
-Nicholas I
--
Sent via pgsql-sql mailing list
The simple answer is to pg_dump both tables and compare the output
with diff.
Other than that, I think you'll need a custom program.
On 29/04/2009, at 10:33 PM, Pawel Socha wrote:
2009/4/29 Nicholas I nicholas.domni...@gmail.com:
Hi,
can anybody me suggest me, how to compare two tables
17 matches
Mail list logo