| From: | John DeSoi <desoi(at)pgedit(dot)com> |
|---|---|
| To: | Lester <lesterewing(at)mac(dot)com>, pgsql-novice Novice <pgsql-novice(at)postgresql(dot)org> |
| Cc: | The PandaWare Company <lists(at)pandaware(dot)com>, Ries van Twisk <ries(at)vantwisk(dot)nl> |
| Subject: | Re: HELP! Data needed out of pgsql! |
| Date: | 2009-08-20 13:09:26 |
| Message-ID: | 3061F95B-2278-48AF-8EF6-5A7EAC2343B2@pgedit.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lester | 2009-08-20 13:15:34 | Re: HELP! Data needed out of pgsql! |
| Previous Message | Oliveiros C, | 2009-08-20 12:18:57 | Trouble with postgres admin user's password on Windows |