| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> | 
|---|---|
| To: | "Kevin Martins *EXTERN*" <martins506(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> | 
| Subject: | Re: Write in file from postgres | 
| Date: | 2008-04-10 12:27:14 | 
| Message-ID: | D960CB61B694CF459DCFB4B0128514C201FA5F37@exadv11.host.magwien.gv.at | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Kevin Martins wrote:
> Hello everybody,
> First off all I am new in postgres but allready got some questions. It's 
> possible to wirte in a file from postgres?
First off, if you write to a mailing list you should first learn how to
write an e-mail. Really.
Core PostgreSQL does not have such a function; you'd have to write it
yourself in C.
There is, however, a function "pg_catalog.pg_file_write(text, text, bool)"
in the "adminpack" contrib module that you could (ab)use for your purposes.
This function may only be used by a superuser, and it would not be a good
idea to have it otherwise.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Markus | 2008-04-10 12:29:53 | Re: howto set a variable in transaction context | 
| Previous Message | Dan99 | 2008-04-10 11:57:43 | Re: slow pgsql tables - need to vacuum? |