2010/7/26 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. > > Thanks in advance! > Scott
You can use COPY but you won't easily have the DDL, just the data. -- Vincenzo Romano NotOrAnd Information Technologies NON QVIETIS MARIBVS NAVTA PERITVS -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
