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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
