Hi, >In an effort to do some general cleanup in my database functions, I >dumped the schema (pgdump -s) and the data (pgdump -a) to seperate text >files. I'm using a similar method for my own project. But I dump the data with the -d or -D option. This ist not as fast as the raw copy but more flexible. Maybe you should give it a try. If you rename some colums of your table, you should use -d (propert INSERT commands instead of COPY). If you reorder the colums of your tables you should use -D (propert INSERT with explicit Attributenames). You cannot do both (rename and reorder columns)! Andre
BEGIN:VCARD VERSION:2.1 N:Schnabel;Andre FN:Andre Schnabel NICKNAME:Thalion X-WAB-GENDER:2 BDAY:19720509 EMAIL;INTERNET:[EMAIL PROTECTED] EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20010710T193556Z END:VCARD
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]