Re: Problems with \copy and delimiters ','

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with \copy and delimiters ','
Date: 2004-01-16 19:51:57
Message-ID: 6086.1074282717@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> I want to do this
> \copy table_name from 'table_name.cdf' delimiters ',';

> But I get:
> \copy: parse error at "delimiters"

Looking at the psql code, it evidently wants "with delimiter" ...

regression=# \copy table_name from 'table_name.cdf' with delimiter ','
table_name.cdf: No such file or directory

> 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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-16 19:54:46 Re: plpythonu AKA am I crazy? or....
Previous Message Melanie Bergeron 2004-01-16 19:22:19 Re: [GENERAL] problem starting postmaster as a service