Re: Write in file from postgres

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: Raw Message | Whole Thread | 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

In response to

Browse pgsql-general by date

  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?