Problems with \copy and delimiters ',' - Mailing list pgsql-general

From Bill Moran
Subject Problems with \copy and delimiters ','
Date
Msg-id 400834B0.9010001@potentialtech.com
Whole thread Raw
Responses Re: Problems with \copy and delimiters ','  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm having some problems using \copy

I have a directory full of test data that I want to be installed automatically
when "make database" is issued.  While the Makefile rules would seem simple, I'm
having some trouble.

I want to do this
\copy table_name from 'table_name.cdf' delimiters ',';

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

A similar command:
copy table_name from '/path/to/file/table_name.cdf' delimiters ',';
works fine, but this makes things complicated, as I don't know the path to the
files until it happens (who knows where the tarball will be unpacked, I want to
give a relative path, not an absolute).

The documentation I've found on \copy says to see the docs on copy ;)

Does the \copy command not support "delimiters"?  This is 7.4 on FreeBSD 5.1.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com


pgsql-general by date:

Previous
From: "Rick Gigger"
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)
Next
From: David Garamond
Date:
Subject: Re: Creating GUID