I have a perl program that I use (also) to copy a database to a
perfect clone having a different name. To perform the operation I
execute from perl the following shell pipe
pg_dump -U postgres -h db_server database_name | psql -U postgres -h
db_server database_name_backup
I'd like to perform the same operation using SQL statement. Is it
possible?
The problem with the current implementation is that sometime pd_dump
and psql ask for password but I want to create the database copy
without any user typing (it is a cron script).