SQL alternative to pg_dump

From: "Envex Developments" <mwagner(at)envex(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: SQL alternative to pg_dump
Date: 2002-12-18 06:19:42
Message-ID: 004e01c2a65d$74cf0990$04f65618@mattbh97ynudvv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2002-12-18 06:59:04 Re: datetime
Previous Message Arindam Haldar 2002-12-18 06:19:39 unsubscribe