Skip site navigation (1) Skip section navigation (2)

Re: Newbie trying to load table with data...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Newbie trying to load table with data...
Date: 2002-08-13 21:11:29
Message-ID: 1217.1029273089@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Kurt Gunderson <kgunders(at)cbnlottery(dot)com> writes:
> test1=> \copy "k_device" from "/home/kurt/data/sql.device.d" using 
> delimiters '|'

> "/home/kurt/data/sql.device.d": No such file or directory

Almost there.  Try it with single quotes or no quotes around the
filename --- double quotes are for SQL identifiers, which the filename
is not.  I tried

test72=# \copy "z" to "barf" using delimiters '|'

which worked, but what I got was

-rw-r--r--   1 tgl        users            0 Aug 13 17:08 "barf"


			regards, tom lane

In response to

pgsql-novice by date

Next:From: Oliver ElphickDate: 2002-08-13 21:23:29
Subject: Re: Newbie trying to load table with data...
Previous:From: Chad ThompsonDate: 2002-08-13 20:31:23
Subject: Re: I need to know password for postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group