Re: pg_dump error

From: Philip <silvermaple(at)usermail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump error
Date: 2004-05-24 14:51:17
Message-ID: 20040524095117.3e07754c.silvermaple@usermail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At some time fairly close to Mon, 24 May 2004 14:03:28 +0100,
rumor has it that Paul wrote:

> On 24/05/2004 08:01 Philip wrote:
> > I've got a _lot_ to learn about databases! *smiles* By looking at
> > the size of the dumped file there is not much data missing, but I
> > like your idea of doing each table. (I didn't know that was
> > possible...) Do you have any tips on where I go to figure out how to
> > show a list of the tables so I can dump them? There seems to be a
> > lot of documentation - but so much of it is over my head my eyes are
> > probably glazed over when I got to the good parts... *grin*
>
> Use psql:
>
> psql dbname
>
> then use the \d option. If I were trying to dump all tables
> individually, I'd use psql's \o <filename> command to direct output to
> a file before issuing the \d. Then I'd hack that file in a text editor
> to create an appropriate shell script with commands of the form:
>
> pg_dump -t table database >table.txt

Got it!! Thank you, thank you! I feel like I'm making progress. I've got
to be careful, though or I might actually _learn_ this stuff... :)

I think I had done some stuff from that shell 'cause it looks quite
familiar - but I belive that was 2 year ago. I knew such a tool existed,
just couldn't remember what it was.

Again, thanks!

Philip

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-05-24 15:40:10 Re: how many record versions
Previous Message Dane Dwyer 2004-05-24 14:35:03 vacuumdb: vacuuming of database "xxx" failed: ERROR: failed to re-find parent key in "pg_class_relname_nsp_index"