Обсуждение: pg_dump syntax

Поиск
Список
Период
Сортировка

pg_dump syntax

От
"Michael Schmidt"
Дата:
Folks,
Sorry to be a bother, but I can't figure out how to do pg_dump of a database with jdbc.  I've tried a variety of syntaxes to no avail and searched through the archives and the web with no help.  Here is my last attempt
 
SELECT pg_dump -Fc -f E:\backup\test.pgb npbase
 
What am I doing wrong?
 
Thanks
Michael Schmidt

Re: pg_dump syntax

От
Oliver Jowett
Дата:
Michael Schmidt wrote:
> Folks,
> Sorry to be a bother, but I can't figure out how to do pg_dump of a
> database with jdbc.  I've tried a variety of syntaxes to no avail and
> searched through the archives and the web with no help.  Here is my last
> attempt
>
> SELECT pg_dump -Fc -f E:\backup\test.pgb npbase
>
> What am I doing wrong?

pg_dump is not a SQL command implemented by the DB backend. It is an
executable client program that connects to the DB backend itself and
runs various SQL queries to extract the database structure and data.

If you want to run pg_dump from Java, you need to be using
Runtime.exec() or similar.

You could also reimplement pg_dump's logic using JDBC, but I strongly
recommend you don't do that!

-O