Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-03 Thread john . rylander
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

Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-03 Thread john . rylander
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

Re: [pgadmin-support] COPY permissions problem - Windows XP

2006-01-02 Thread john . rylander
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