2010/7/27 Scott Frankel <fran...@circlesfx.com>: > > Hi all, > > Is it possible to perform an SQL Dump without using pg_dump? > > I have a special case situation wherein my application has access to a > remotely-hosted PG (8.3) database, but does not have access to its admin > tools. (There's a longer backstory here that I'm happy to explain if > necessary.) I'm looking for an efficient way to dump all the data in the DB > without having to SELECT * on each table.
COPY might be of use: http://www.postgresql.org/docs/8.3/interactive/sql-copy.html though you will have to specify each table of course. Ian Barwick -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
