Re: HELP! Data needed out of pgsql! - Mailing list pgsql-novice

From John DeSoi
Subject Re: HELP! Data needed out of pgsql!
Date
Msg-id 3061F95B-2278-48AF-8EF6-5A7EAC2343B2@pgedit.com
Whole thread Raw
In response to HELP! Data needed out of pgsql!  (Lester <lesterewing@mac.com>)
Responses Re: HELP! Data needed out of pgsql!
List pgsql-novice
Lester,

The docs to pg_dump are here:

http://www.postgresql.org/docs/8.3/interactive/app-pgdump.html

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
> BTW.
>
>
> Thanks for your help so far!
>
> Lester
>


John DeSoi, Ph.D.





pgsql-novice by date:

Previous
From: "Oliveiros C,"
Date:
Subject: Trouble with postgres admin user's password on Windows
Next
From: John DeSoi
Date:
Subject: Re: HELP! Data needed out of pgsql!