| From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
|---|---|
| To: | Josh Harrison <joshques(at)gmail(dot)com> |
| Cc: | General postgres mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Question about COPY command |
| Date: | 2009-01-09 10:54:19 |
| Message-ID: | 1231498459.3036.155.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 copying from 'filename' and copying from 'stdin' ???
>
The most important distinction is that 'filename' refers to a file
residing on the *server*, but STDIN is clientside.
For security, the file variant requires superuser privileges.
gnari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-01-09 11:12:21 | Re: RCA for MemoryContextAlloc: invalid request size(Known Issue) |
| Previous Message | Yogvinder Singh | 2009-01-09 10:47:09 | Re: RCA for MemoryContextAlloc: invalid request size(Known Issue) |