On fim, 2009-01-08 at 08:39 -0500, Josh Harrison wrote:
> 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 copy
2009/1/9 Josh Harrison :
> 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) ?
Should be possible; just got to make sure that you have all the for
On Thu, Jan 8, 2009 at 8:52 AM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to Josh Harrison :
> > Hi,
> > A basic question about the COPY command syntax
> > This is the syntax in the postgres manual.
> >
> > COPY tablename [ ( column [, ...] ) ]
> >
> > FROM {
On 08/01/2009 13:39, Josh Harrison wrote:
> What is the difference between copying from 'filename' and copying from
> 'stdin' ???
You'll see COPY from stdin in pg_dump scripts - when restoring via psql,
the entire input to psql is coming from stdin, so COPY FROM stdin tells
it to expect the dat
In response to Josh Harrison :
> 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 cop
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' ???
Thanks
Josh
