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 :
Hi,
can anybody me suggest me, how to compare two tables of different
database.
-Nic
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
27;, f2 will have a second
copy with the same value in the new row that is created as part of the
update. It's all part of the MVCC architecture. There may be some
uncommon exceptions to this rule, but I'm not sure.
Adam Ruth
---(end of
broadcast)---
Sounds like you may want to concatenate the columns:
... order by table1.name || table2.name
The sorting would then be performed on both of the them as though they
were one column.
Adam Ruth
On Jan 2, 2004, at 8:04 PM, Michael Glaesemann wrote:
On Jan 2, 2004, at 8:55 PM, Andy Lewis wrote
I didn't notice an OS X version on their website. Do they have one?
On Dec 31, 2003, at 12:57 PM, Andy Lewis wrote:
I would have to agree with EMS-HiTech's product also. A feature rich,
product, very responsive tech support/bug report. PGManager beats the
competition hands down.
Andy
-Origi
I currently use XCode from Apple (their free development environment).
I create sql scripts which I then either execute directly in psql or
copy and paste into an open psql session for small changes.
On Dec 30, 2003, at 9:05 AM, beyaRecords - The home Urban music wrote:
Hi,
can anyone recommen
