| From: | koff10 <koff10(at)hotmail(dot)com> |
|---|---|
| To: | Mukesh Rajpurohit <vivasvan1902(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Comparing 2 data base or 2 tables |
| Date: | 2021-06-28 13:22:29 |
| Message-ID: | DBAPR01MB6662F11E117621B132D62D54CA039@DBAPR01MB6662.eurprd01.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Thanks all for your feed back
@Mukesh , I daily use postgres_fdw but not plz . How does it work?
Le 28/06/2021 à 14:04, Mukesh Rajpurohit a écrit :
> You may use EXCEPT keyword to compare two tables in two databases, plz
> use postgres_fdw for connectivity.
>
> Thanks
> Mukesh
>
> On Mon, Jun 28, 2021, 4:42 PM koff10 <koff10(at)hotmail(dot)com
> <mailto:koff10(at)hotmail(dot)com>> wrote:
>
>
> Hi All,
> I am in trouble with a production database.So, I'm looking for a
> script or tools comparing 2 postgre database schemas
> and extract data differences.
> I need a little help please.
> thanks lot.
>
> koff Berta
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2021-06-28 15:58:18 | Re: PostgreSQL: A command is already in progress in .NET Windows application |
| Previous Message | Mukesh Rajpurohit | 2021-06-28 12:04:24 | Re: Comparing 2 data base or 2 tables |