Re: Data comparison

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi 

You can also use pgAdmin for schema comparison, please check the below link.

https://www.pgadmin.org/docs/pgadmin4/8.8/schema_diff.html#:~:text=Click%20on%20Schema%20Diff%20under,click%20on%20the%20Compare%20button.

Thanks
Kashif Zeeshan

On Mon, Aug 12, 2024 at 3:48 PM Muhammad Usman Khan <usman.k@xxxxxxxxxxx> wrote:
Dear Harish,
If you are referring to data validation then the following query might give you the desired results

/pg_dump -U postgres -s target -p 5334 > /tmp/db2_schema.sql ./pg_dump -U postgres -s source > /tmp/db1_schema.sql diff /tmp/db1_schema.sql /tmp/db2_schema.sql

Adjust your ports and databases name accordingly

Regards
Muhammad Usman Khan



On Mon, 12 Aug 2024 at 15:41, Harish Harish <hpt3009@xxxxxxxxx> wrote:
Dear Admins

Is there any way to do data comparison for the database scheme in PostgreSQL between old version(10) and new version (15.0).

Just migrated database from version 10 to 15.

Much appreciate your help.

Regards,
Hari

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux