Delete and restore postgress database in sikuli

Question

I have used below code to delete postgress database. My issue is I am unable to find query which would restore database. Please provide your assistance. thank you!!

from __future__ import with_statement
import sys
from sikuli import *
from com.ziclix.python.sql import zxJDBC
load("C:\\Test\\SikuliX\\postgresql-9.4.1207.jre6")

connection2 = zxJDBC.connect('jdbc:postgresql://127.0.0.1/?stringtype=unspecified', 'postgres', 'pswd@123', 'org.postgresql.Driver')
connection2.autocommit = True
curs = connection2.cursor()

curs.execute('DROP DATABASE  IF EXISTS  sampledb')

curs.execute( < I need query to restore database>)

Answer 1

Found workaround for this, instead of restore we can copy the database curs.execute('CREATE DATABASE [newdb] WITH TEMPLATE [originaldb] OWNER dbuser')

Answer 2

There is no "command" to restore a postgresql database. Usually a backup consists of a very large bunch of commands that piece by piece create a database that is mostly identical to what you have backupped before. Your only possibility is to use the shell command pg_restore.

Oh, and your question has nothing to do with sikuli-ide. The problem is programming language agnostic.