Postgres "copy" problem...

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