Problems on "copy" statement - Mailing list pgsql-novice

From Leung Wing Lap Ellery
Subject Problems on "copy" statement
Date
Msg-id 425D2CB1.4050901@netvigator.com
Whole thread Raw
Responses Re: Problems on "copy" statement  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
Hi all!

When I want to use "copy" to move data in .csv, which has been formatted
to tab-formatted file, to my postgresql as follow (DB name: test,
tablename: hsi):

copy hsi from 'c:\java\hsi.txt'

it generated error:

ERROR:  relation "hsi" does not exist
copy hsi from 'c:\java\hsi.txt'


if I use double quoted:

copy hsi from "c:\java\hsi.txt"

it generated:

ERROR:  syntax error at or near ""c:\java\hsi.txt"" at character 15


Can anyone please tell me what's wrong with the above statements?

Thanks in advance for your kind help!

pgsql-novice by date:

Previous
From: David Orme
Date:
Subject: Update from a subquery using where to match entries between tables
Next
From: "Keith Worthington"
Date:
Subject: Re: Problems on "copy" statement