Postgres Pro
Downloads
Home   >   mailing lists

Multiple COPYs - Mailing list pgsql-general

From rasdj@frontiernet.net
Subject Multiple COPYs
Date
Msg-id 1118939523.242964.265050@z14g2000cwz.googlegroups.com
Whole thread Raw
Responses Re: Multiple COPYs  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Multiple COPYs  (Douglas McNaught <doug@mcnaught.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "eblues"
Date:
Subject: Help: chinese character set support (EUC_TW to/from BIG5 conversion)
Next
From: stig erikson
Date:
Subject: psql: FATAL: database "template1" is not currently accepting connections