I.TAKING TABLE STRUCTRE BACKUP WITH THEIR’S OBJECT FILE NAME : In this script helpful to take backup (DDL’s) of procedure, function & table definition with seperate file system (object name) based on postgres schema , this script is mostly used …
In this shell script will help you to take the backup of PostgreSQL table definition with different or individual file name as schema based. # Config: DB=”DBA” U=enterprisedb export PGPASSWORD=”tcs45″ export PGPORT=”5444″ export PGHOST=”20.0.4.101″ TABLES=”$(/opt/edb/as9.6/bin/psql -d $DB -U $U -t …