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