[postgis-users] quickie question

[Markus Schaber]

Hi, Jessica,

Jessica M Salmon wrote:

> Anyone know off hand how to direct query output to a file from within a
> plpgsql function?
> 
> I'm trying to use PERFORM ''\\o filename'', then SELECT..., but I get a
> message saying "ERROR:  SELECT query has no destination for result data".
> Any tips would be greatly appreciated.

As far as I can see, "\o filename" is neither a valid plpgsql construct,
nor a valid SQL construct.

I know that psql knows \o, but that won't apply to any backend language.

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org