PostgreSQL metadata grabber and comparer
Project description
PostgreSQL metadata (DDL) grabber and comparer
Dependencies
Installation
pip install psycopg2 pg-metadata
Usage
1 ) Create file _Connect.py
with connection params:
# Source database for comparing
# Database for grabbing
PG_SOURCE = {
"host" : "",
"port" : 5432,
"database" : "",
"username" : "",
"password" : "",
}
# Target database for comparing
PG_TARGET = {
"host" : "",
"port" : 5432,
"database" : "",
"username" : "",
"password" : "",
}
# Excluded namespaces
EXCLUDE_SCHEMAS = [
"information_schema",
"pg_catalog",
"pg_temp",
"pg_temp_1",
"pg_toast",
"pg_toast_temp_1"
]
# Path with compare folder
PATH_COMPARE = "./compare"
2 ) To grab database metadata run zzz_Grabber.py
.
3 ) To compare databases run zzz_Compare.py
.
Links
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
pg_metadata-0.5.4.tar.gz
(14.1 kB
view hashes)
Built Distribution
Close
Hashes for pg_metadata-0.5.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 611e94468b591384d51d125468389ed7fd50920b975751cb23a2b3464a82f75d |
|
MD5 | 95f542a22345bf6e5c1ff1ced6f8b6d7 |
|
BLAKE2b-256 | a729e00ef264c46fc18c99748adcbf57a596730858e32b481b75371f85830a7c |