| From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
|---|---|
| To: | Christopher Condit <condit(at)sdsc(dot)edu> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgsql and streams |
| Date: | 2006-03-30 09:07:03 |
| Message-ID: | 442B9FB7.8040304@wildenhain.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Christopher Condit schrieb:
> Back to this thread - I realize that in the "COPY TO" documentation, it
> states the CSV file used for loading must be on the server's disk. If I
> can't put files on the server's disk, I'm curious if I can use the STDIN
> option from my JDBC client to load the data to the server? Using psql I
> can stream data after the call. Is there anyway to accomplish the same
> thing with JDBC?
>
Not sure about JDBC but you can in fact stream your data to COPY via
STDIN - which is the network socket of your database connection.
I'm using this with python for example.
Regards
Tino
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bozhidar Mihaylov | 2006-03-30 10:13:32 | Slony-I for circular replication |
| Previous Message | Achilleus Mantzios | 2006-03-30 08:46:44 | Re: [SQL] Flight numbers data |