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