Gia sou Panteli,
are you suggesting that the results are incinsistent and unpredictable with
every run?
pls present a case demontsrating the problem.
On Τετ 07 Νοε 2012 10:36:34 pantelis vlachos wrote:
I was trying to find a substring on a text (data type) column like 'cat foo dog
...'.
I use
Thanks Willem for the advise to stick to SQL solutions where possible.
A simple SQL solution would be to perform a full out join on the two tables.
On Mon, Nov 12, 2012 at 12:13 PM, Willem Leenen
wrote:
>
> My advice: for comparing databases, tables , data etc, don't go scripting
> yourself. T
Hi,
On Sun, 2012-11-11 at 08:43 +0530, saikiran mothe wrote:
> How can i compare two tables in PostgreSQL.
http://pgfoundry.org/projects/pg-comparator/
Open source, under active development.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
Postg
According to Dr Google, this tool may suit your needs:
http://www.sqlmanager.net/en/products/postgresql/datacomparer?gclid=CImMsbmLybMCFQRc3godNgQAdQ
For business use only $133.
Date: Mon, 12 Nov 2012 11:00:32 +0300
Subject: Re: [SQL] How to compare two tables in PostgreSQL
From: kama
My advice: for comparing databases, tables , data etc, don't go scripting
yourself. There are already tools in the market for that and they give nice
reports on differences in constraints, indexes, columnnames, data etc.
I used dbdiff from dkgas.com, but it seems the website is down.
I wou
If you would like to compare their contents perhaps this may help.
Write a select statement containing the fields for which you would like to
compare data for, you may want to leave out fields whose values are
provided by default for example fields populated from sequence object
and/or timestamp fi
