BTW, copying the relevant CSV file to the "My Documents" folder of the
"postgres" user did not make things work with pgAdmin III Query
(1.4.1)--same permissions problem as noted in the original message:
ERROR: could not open file "C:\Documents and Settings\postgres\My
Documents\Cumulative.csv" fo
Jim,
Your reference to \COPY proved extremely useful for me--thanks!
At first, I didn't much pay attention to it, because the portion of the
docs you excerpted focussed on STDIN; but when I read the whole doc set
for the command, it was clear that I could indeed plug in any old file
spec as with
Same problem here, and same mystification.
As someone coming from a basically single-user perspective who's
looking at PostgresQL mainly for capacity (Microsoft Access 2003 keeps
running out of space even though the tables I'm working with are under
100 MB) and license reasons (I'm uncomfortable w