SQL alternative to pg_dump - Mailing list pgsql-general

From Envex Developments
Subject SQL alternative to pg_dump
Date
Msg-id 004e01c2a65d$74cf0990$04f65618@mattbh97ynudvv
Whole thread Raw
Responses Re: SQL alternative to pg_dump  (Neil Conway <neilc@samurai.com>)
Re: SQL alternative to pg_dump  (frbn <frbn@efbs-seafrigo.fr>)
List pgsql-general
Hey there,

Quick question for you...  Currently developing a software program, which
will be distributed to many people, hence, hosted on many different servers.
Since PostgreSQL is quite rare in the main-stream hosting business, many
people will most likely host the PostgreSQL database on a remote server, and
their local server won't have PostgreSQL installed.

I need a backup function for the software.  I've found "pg_dump", and the
COPY statement.  I would very much like to use pg_dump, as it dumps
everything...  tables, functions, sequences, triggers, ect...

However, since many of the servers hosting the software won't have
PostgreSQL installed locally, there'll be no pg_dump.

Just wondering, any way around this?  Is there an alternate of pg_dump,
which can be run as SQL statement(s)?

Thanks,
Matt





pgsql-general by date:

Previous
From: Toby Tremayne
Date:
Subject: return setof record from function with dynamic query
Next
From: Arindam Haldar
Date:
Subject: unsubscribe