Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get text for a plpgsql variable from a file. - Mailing list pgsql-general

From Pavel Stehule
Subject Re: How to get text for a plpgsql variable from a file.
Date
Msg-id 162867790912162148w39dbfc25g88f3efa17023a4ed@mail.gmail.com
Whole thread Raw
In response to Re: How to get text for a plpgsql variable from a file.  (Erwin Brandstetter <brsaweda@gmail.com>)
List pgsql-general
Tree view 
2009/12/17 Erwin Brandstetter <brsaweda@gmail.com>:
> On Dec 16, 10:47 pm, pavel.steh...@gmail.com (Pavel Stehule) wrote:
>> hello
>>
>> look on orafce from pgfoundry. There modul utl_file
>>
>> http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#UTL_FILE
>
>
> Thanks Pavel, that should do the trick.
>
> I assume then, there is no easier built-in way in standard postgres?
>

PostgreSQL 8.3 and higher can read file from pg data directory.  That is all

Regards
Pavel

>
> Regrads
> Erwin
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Automatic truncation of character values & casting to the type of a column type
Next
From: Sam Jas
Date:
Subject: Fw: password authentication failed