Skip site navigation (1) Skip section navigation (2)

Re: HELP! Data needed out of pgsql!

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 (view raw or flat)
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.





In response to

Responses

pgsql-novice by date

Next:From: LesterDate: 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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group