Re: COPY

igor dijo:

> I am using the copy command for copy very large database. But I am
> using it like it's described in tutorial "copy table from
> '/file'..etc". So it takes a lot of time copy each table. Is there any
> way how to create some function to copy all the directory ,or
> something like foreach (table)...? That directory would contain
> prepared tables already. I do not know lot about PostgreSQL functions
> ,so I am asking some advice.

It should be very simple to write on in Perl or shell to do that,
something like

for i in /where/dumps/reside/*.dump; do
psql -c "copy table from $i" && mv $i $i.old
done

--
Alvaro Herrera (<alvherre[a]atentus.com>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiánse", y el computador dirá "especifique el tipo de ciervo"
(Jason Alexander)