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: (view raw or whole thread)
Lists: pgsql-novice

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

John DeSoi, Ph.D.

In response to


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-2015 The PostgreSQL Global Development Group