shayonj / pg_easy_replicate

Easily setup logical replication and switchover to new database with minimal downtime
MIT License
941 stars 17 forks source link

List only permanent tables #113

Closed faridco closed 6 months ago

faridco commented 6 months ago

In order to list tables suitable for replication we should select tables with relpersistence = 'p' omitting UNLOGGED tables, which are listed as BASE TABLE in information_schema.tables