Skip site navigation (1) Skip section navigation (2)

SQL statements equivalent to pg_dump

From: "Jason Tan Boon Teck" <tanboonteck(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL statements equivalent to pg_dump
Date: 2007-11-22 03:44:05
Message-ID: dd8f6c970711211944j26035fe9i56f4bf9e115700e5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I'm trying to create an adhoc backup feature inside an application using
PHP.

I could perform a pg_dump using the shell, but is there SQL statements that
could do the same thing without having to use PHP to go to shell and then
having to change users to root, postgres, etc. just to make a dump? I'm
hoping to minimize security risks.

Thanks in advance.

-- 
Jason Tan Boon Teck

pgsql-novice by date

Next:From: Nikolay SamokhvalovDate: 2007-11-22 10:42:17
Subject: Re: xpath question
Previous:From: Oliver ElphickDate: 2007-11-22 03:04:04
Subject: Re: sql file in the tutorial directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group