Postgres Pro
Downloads
Home   >   mailing lists

COPy command question - Mailing list pgsql-general

From SHARMILA JOTHIRAJAH
Subject COPy command question
Date
Msg-id 373693.49047.qm@web110704.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: COPY command question
Re: COPy command question
List pgsql-general
Tree view
Hi,
A question about the Postgresql's COPY command.

This is the syntax of this command from the manual
COPY tablename [ ( column [, ...] ) ]
    FROM { 'filename' | STDIN }
    [ [ WITH ] 
         .....
I want to migrate my tables from Oracle to Postgres. 
The COPY FROM command can take input from 'file' or 'STDIN'.
Is it possible for the COPY command to take its input from a
java program(which contains the oracle resultset) or any other way?

I know I could get the Oracle rows in a csv format but 
Im trying to get it done without any file in between ? 

In short is it possible to use this 'COPY' command to migrate my tables' 
data from Oracle to Postgresql without using any filein between?

Thanks
Sharmila





pgsql-general by date:

Previous
From: "Ing. Eris Gomez"
Date:
Subject: Saber cuando se dispara el trigger (After: insert,update,delete)
Next
From: Richard Huxton
Date:
Subject: Re: postmaster LISTENing on UDP port 32938