On 14/06/2010 12:28, Frank Church wrote:
> Are there SQL commands that can do a backup over a client connection,
> rather than from the command line like pgsql etc?
No, not that I'm aware of.
> By that I mean some kind of SELECT commands that can retrieve the
> database's content as SQL commands that can be replayed to a server to
> restore it, rather than something that saves directly to file, or
> passes it through a pipe?
What exactly are you trying to do? If you're building database backup
functionality into an application, you're better off just spawning a
sub-process with pg_dump.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie