Postgres "copy" problem...

[Tilby, Lynn # PHX]

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)