> Hi, > A basic question about the COPY command syntax.... > This is the syntax in the postgres manual. > > COPY tablename [ ( column [, ...] ) ] > > FROM { 'filename' | STDIN } > ...... > ..... > > What is the difference between copying from 'filename' and copying from 'stdin' ???
Within psql, stdin is your keyboard. Otherwise, you can use COPY in a UNIX-PIPE.
Thanks... Is it possible to use COPY command to copy data from oracle to postgresql database? I currently use jdbc to do this but its really slow...so I wanted to try the COPY command ? So if i have to do this using COPY command then I have to 'exp' the oracle table to a flat file and read it using COPY command into postgresql tables ? Is there a way to do this without dumping the data into a file ?
My question is is it possible to read the oracle data from the oracle database and copy them into postgresql database directly by using COPY command instead of jdbc preparedstatement(INSERT command) ?
Thanks Josh
Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net