Re: Frustration with \copy - Mailing list pgsql-general

From Tom Lane
Subject Re: Frustration with \copy
Date
Msg-id 27488.1284142449@sss.pgh.pa.us
Whole thread Raw
In response to Frustration with \copy  (Ralph Smith <rsmith@10kinfo.com>)
List pgsql-general
Ralph Smith <rsmith@10kinfo.com> writes:
> I have a one column .txt file on Ubuntu that I'm trying to upload, and ....
>     \copy new_coupons '/home/rsmith/testfile.txt'

I think you need
    \copy new_coupons from '...'

Like it says, it's supposed to match the backend syntax, modulo needing
a starting backslash and no ending semicolon.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: sql DO in rule 9.0rc1
Next
From: Tom Lane
Date:
Subject: Re: sql DO in rule 9.0rc1