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.6.1.tar.gz
(14.5 kB
view hashes)
Built Distribution
Close
Hashes for pg_metadata-0.6.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a8fec9b34dd730e7ba2c8389a0da5b7e3169919d6ce4975c4430371e437e4413 |
|
MD5 | c384e8281729b4e9e45750fe7a8bd7f2 |
|
BLAKE2b-256 | b6f7d5b1928fa1e24886c7f2d1851feb973414201548b2eb2064fe15c01046e1 |