Greg, The desired COPY FILE functionality for a local non-superuser user would require a local file. That file is available locally. A suggested workaround COPY with STDIN would involve the TCP pipe. This does of course have the support for remote uploads. But I am not currently interested in remote data transfers. Regards Bernard On 19 Aug 2005 02:03:54 -0400, you wrote: > >Oliver Jowett <oliver@xxxxxxxxxxxxx> writes: > >> Bernard was also objecting to the overhead of pushing the data down a >> TCP pipe when it's already available locally, I think.. I didn't find >> any real difference there when I compared the two methods, though. > >What makes you think it's necessarily available locally? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend