Re: [GENERAL] Frustration with \copy

2010-09-10 Thread David Fetter
On Fri, Sep 10, 2010 at 10:25:52AM -0700, Ralph Smith wrote: > Yes, we are planning to upgrade to 8.3, but now I'm stuck w/ 7.4. Don't stay stuck there too long. It's about to end its life, as are 8.0 and 8.1, later this year. http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy >

Re: [GENERAL] Frustration with \copy

2010-09-10 Thread Tom Lane
Ralph Smith 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 backsl

[GENERAL] Frustration with \copy

2010-09-10 Thread Ralph Smith
As someone famous once said: The documentation I've found on \copy says to see the docs on copy ;) It's *supposed* to match the backend syntax, but seems a few bricks shy of a load at the moment. Anyone feel like fixing it? See parse_slash_copy() in src/bin/psql/copy.c. Th