---------- Initial Header ----------- >From : "Fouejieu louis" [EMAIL PROTECTED] To : [EMAIL PROTECTED] Cc : Date : Mon, 10 Nov 2003 14:49:47 +0000 Subject : Re: [sqlite] COPY
> >Hi all, > > > >I would like to know if it is possible to dump a sqlite database > >with format COPY. > >I tried sqlite mydb .dump > >but it uses the INSERT command instead, is there a way to change this > >behavior? > > > Hi Jo, > > I don't know if it will be help you, but i have already make a successfull > COPY like this: > > // 1st Copy data from a hardisk 'Source_data.csv'(for example) to a > temporary table 'Temp_tb' > COPY Temp_tb FROM 'C:/path/to/Source_data.csv' USING DELIMITERS ';' ; > > // 2nd Insert the data from 'Temp_tb' in target table 'Target_tb' > INSERT INTO Target_tb (Filed1, Field2, Field3) SELECT DISTINCT Filed_1, > Field_2, Field_3 FROM Temp_tb; > > > PS: Field1 from Target_tb muss have the same Tipe with Field_1 from Temp_tb > > _________________________________________________________________ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > Thank you to reply to my question Cappucino, but my problem is of a different kind. I need to export data from sqlite and import it in PostgreSQL, I would like to use the COPY format because it is faster than INSERT command, but seems to me that sqlite is not able to export data in such format. Jo --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
