Multiple COPYs

From: rasdj(at)frontiernet(dot)net
To: pgsql-general(at)postgresql(dot)org
Subject: Multiple COPYs
Date: 2005-06-16 16:32:03
Message-ID: 1118939523.242964.265050@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Having a great time with PG - ported an erp from oracle and db2. First
I tried MySql but choked somewhere in the 900 table region. I have a
python script to translate the syntax and it loads about 2000 tables.

Now I want to COPY my dumps - I have 1 data dump for each table. Any
tips on what to use so that I can read the file name into a variable
and pass it as the file name in the COPY command and have one script
load all my tables?

Thanks for any help.

Rasta DJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-06-16 16:38:50 Re: pgavd status
Previous Message Douglas McNaught 2005-06-16 16:29:43 Re: Autovacuum in the backend