Postgres Pro
Downloads
Home   >   mailing lists

Re: can we write to a flat file from Postgresql procedure - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: can we write to a flat file from Postgresql procedure
Date
Msg-id Pine.LNX.4.30.0107111646070.679-100000@peter.localdomain
Whole thread Raw
In response to can we write to a flat file from Postgresql procedure  (R Vijayanath <vijayanath@yahoo.com>)
Responses Re: can we write to a flat file from Postgresql procedure  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-sql
Tree view 
R Vijayanath writes:

> It would be great if you can tell me if I can write a
> procedure that can write the output to the OS(Linux
> OS) file.

You could try out PL/sh for that.

http://www.postgresql.org/~petere/plsh.html

YMMV

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: cumulative sum in aggregate query.
Next
From: Alex Pilosov
Date:
Subject: Re: can we write to a flat file from Postgresql procedure