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

Re: dumping strategy

From: Gerald Gutierrez <gml1(at)coldresist(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: dumping strategy
Date: 2001-05-31 17:16:09
Message-ID: 5.1.0.14.0.20010531101426.00a80da0@coldresist.com (view raw or flat)
Thread:
Lists: pgsql-general
> > for i in t1 t2 t3; do pg_dump -t$i mydb > $i.tbl; done
>
>This is very nice _if_ I had _really_ named
>my tables like that.

So you do

for i in thistable thattable t1 t2 whatevername; do ...

Unless tables are dynamically created and their names cannot be statically 
known, I don't see any problems.


In response to

pgsql-general by date

Next:From: Luis MagaƱaDate: 2001-05-31 17:26:19
Subject: pg_dump & pg_dumpall problem.
Previous:From: SethDate: 2001-05-31 16:26:43
Subject: outer joins take forever

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