0

Here i have sql server query to take backup of database using stored procedure as shown below:

Example: 

 CREATE procedure DISKBACKUP  @location_dump varchar(255), @databasename varchar(255)                 
   AS                  
  backup Database @databasename to disk=@location_dump          
  ...

Can I do the same in PostgreSQL?

user229044
  • 232,980
  • 40
  • 330
  • 338
Sarfaraz Makandar
  • 5,933
  • 16
  • 59
  • 84
  • No, but you can use pg_dump or simple GUI tool PostgreSQL-backup (http://postgresql-backup.com/) to make PostgreSQL backups –  Sep 07 '16 at 10:15

1 Answers1

2

No, it is not.

pg_dump must be used.

It's often requested, but it's not supported at present, and nobody who requests it ever goes on to do any work to actually make it happen.

Craig Ringer
  • 307,061
  • 76
  • 688
  • 778