Export data from client to server via postgresql ODBC

Question

I wish to upload my text data from client application to server database. Right now, i'm using ODBC to communicate with PostgreSQL. I use ODBC because there is a need to connect to multiple type of databases.

My issue here is, PostgreSQL uses PQgetCopyData to obtain the stdout data when using COPY OUT. So, is there any workaround to obtain the data from output stream without using libpq API and transmit it over by :

SQLExecDirect (hStmst,"COPY <table> FROM STDIN WITH CSV ",SQL_NTS)

?

Chris Travers · Accepted Answer · 2013-05-12 13:36:27Z

1

Basically you have two options. The first is to use the old COPY command (borrowed from Quel interestingly enough). The second is to use a CSV parsing library of your choice and generate INSERT statements.

The tradeoff is that COPY will work MUCH faster, whine INSERT will work on other databases too.

answered May 12, 2013 at 13:36

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Export data from client to server via postgresql ODBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related