Re: [SQL] Using regexp_matches in the WHERE clause

2012-11-27 Thread Willem Leenen
Sounds to me like this: http://joecelkothesqlapprentice.blogspot.nl/2007/12/using-where-clause-parameter.html > To: pgsql-sql@postgresql.org > From: spam_ea...@gmx.net > Subject: [SQL] Using regexp_matches in the WHERE clause > Date: Mon, 26 Nov 2012 13:13:06 +0100 > > Hi, > > I stumbl

Re: [SQL] How to compare two tables in PostgreSQL

2012-11-12 Thread Willem Leenen
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

Re: [SQL] How to compare two tables in PostgreSQL

2012-11-12 Thread Willem Leenen
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