The docs to pg_dump are here:
The above documentation has lots of examples at the end. You probably
want something like:
pg_dump -U db_user_name db_name > ~/Desktop/db_name.sql
P.S. You need to use "reply all" so your response goes back to the list.
On Aug 20, 2009, at 8:58 AM, Lester wrote:
> Hi all,
> I have the password and I was able to use the pgadmin.conf to open
> that file but I don't know how to use pgdump to open the database.
> I'm a newb as it concerns working with terminal. This is for a Mac
> Thanks for your help so far!
John DeSoi, Ph.D.
In response to
pgsql-novice by date
|Next:||From: Lester||Date: 2009-08-20 13:15:34|
|Subject: Re: HELP! Data needed out of pgsql!|
|Previous:||From: Oliveiros C,||Date: 2009-08-20 12:18:57|
|Subject: Trouble with postgres admin user's password on Windows|