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

2012-11-13 Thread Igor Neyman
From: saikiran mothe [mailto:saikiran.mo...@gmail.com] Sent: Saturday, November 10, 2012 10:14 PM To: pgsql-sql@postgresql.org Subject: How to compare two tables in PostgreSQL Hi, How can i compare two tables in PostgreSQL. Thanks, Sai Here is simple sql to show data in table1, but not in ta

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

2012-11-12 Thread Allan Kamau
ad of > creating files and compare them. (got that from Joe Celko ;) ) > > > > -- > Date: Mon, 12 Nov 2012 11:00:32 +0300 > Subject: Re: [SQL] How to compare two tables in PostgreSQL > From: kamaual...@gmail.com > To: pgsql-sql@postgresql.o

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

2012-11-12 Thread Devrim GÜNDÜZ
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

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

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

2012-11-12 Thread Willem Leenen
I would try to stick to SQL solutions as much as possible, instead of creating files and compare them. (got that from Joe Celko ;) ) Date: Mon, 12 Nov 2012 11:00:32 +0300 Subject: Re: [SQL] How to compare two tables in PostgreSQL From: kamaual...@gmail.com To: pgsql-sql@postgresql.org

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

2012-11-12 Thread Allan Kamau
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

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

2012-11-11 Thread Rob Sargentg
On 11/10/2012 08:13 PM, saikiran mothe wrote: Hi, How can i compare two tables in PostgreSQL. Thanks, Sai Compare their content or their definition? -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sq

[SQL] How to compare two tables in PostgreSQL

2012-11-11 Thread saikiran mothe
Hi, How can i compare two tables in PostgreSQL. Thanks, Sai