Your syntax is wrong. Take out the INTO and it should work fine.
HTH
-----Original Message-----
From: Tilby, Lynn # PHX [
mailto:LTilby@simatics.com]
Sent: Tuesday, November 14, 2000 12:40 PM
To: '
plug-discuss@lists.PLUG.phoenix.az.us'
Subject: Postgres "copy" problem...
The following functions failed the regression tests:
float 8
geometry
abstime
select_implicit
select_having
select_views
rules
This is right out of the tutorial:
COPY INTO weather FROM '/home/user/weather.txt'
USING DELIMITERS '|';
I build a table (simulation_stock_tb) which uses float8's and execute
the following:
pma=> copy INTO simulation_stock_tb from '/prgs/db/cps/load_ready3'
USING DELIMITERS ' ';
Using the SAME syntax as the "weather" example I get this error msg.
ERROR: parser: parse error at or near "into"
pma=>
What is the connection (if any) between the float8 in the regression
test and the "parse" error above?
THANKS for your help!
Lynn P. Tilby
Lynn P. Tilby (Lead Programmer/Analyst)
National Data Corporation / Health Information Services
Data Warehousing Solutions
Office: 602 381-9629
Pager: 602 205-1692
Cell: 480 510-4392
Home O: 480 632-8635
Home: 480 632-8633
ltilby@simatics.com (work)
lynn@sol.createv.com (personal)
________________________________________________
See
http://PLUG.phoenix.az.us/navigator-mail.shtml if your mail doesn't post
to the list quickly and you use Netscape to write mail.
Plug-discuss mailing list -
Plug-discuss@lists.PLUG.phoenix.az.us
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)