PgRoutiner Database Management

floki

Feb 11, 2024

List Database Objects

pgroutiner -l | -ls | --ls | --list [ term ]

pgroutiner -l | -ls | --ls | --list [ term ]

Search Database Objects

pgroutiner -s | --s | --search [ term ]

pgroutiner -s | --s | --search [ term ]

View Database Object Definitions

pgroutiner -def | -ddl | --ddl | -definition | --definition [ name|names ]

pgroutiner -def | -ddl | --ddl | -definition | --definition [ name|names ]

PSQL Tool

pgroutiner -sql | -psql | --sql | --psql

pgroutiner -sql | -psql | --sql | --psql

Execution

pgroutiner -x | --x | -exec | --exec | -execute | --execute | --execute [ command|commands|script|dir ]

pgroutiner -x | --x | -exec | --exec | -execute | --execute | --execute [ command|commands|script|dir ]

Insert Scripts

pgroutiner -i | -ins | -inserts | --inserts [ table|tables|view|views|query|queries ]

pgroutiner -i | -ins | -inserts | --inserts [ table|tables|view|views|query|queries ]

Backup and Restore Helpers

pgroutiner --backup [ filename|name_pattern ]

pgroutiner --backup [ filename|name_pattern ]

pgroutiner --restore [ filename|name_pattern ]

pgroutiner --restore [ filename|name_pattern ]

Schema Files and Data Files

pgroutiner -sd | --schema-dump
pgroutiner -sd | --schema-dump -sdf | --schema-dump-file [ schema filename ]

pgroutiner -sd | --schema-dump
pgroutiner -sd | --schema-dump -sdf | --schema-dump-file [ schema filename ]

pgroutiner -dd | --data-dump -dumplist [ object list ]
pgroutiner -dd | --data-dump -dumplist [ object list ] -ddf | --data-dump-file [ data dump filename ]

pgroutiner -dd | --data-dump -dumplist [ object list ]
pgroutiner -dd | --data-dump -dumplist [ object list ] -ddf | --data-dump-file [ data dump filename ]

Database Object Files

pgroutiner -db | --db-objects
pgroutiner -db | --db-objects -dbd | --db-objects-dir [ directory ]

pgroutiner -db | --db-objects
pgroutiner -db | --db-objects -dbd | --db-objects-dir [ directory ]

PgRoutiner Concept

PgRoutiner Code-Gen