| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Erwin Brandstetter <brsaweda(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to get text for a plpgsql variable from a file. |
| Date: | 2009-12-17 05:48:34 |
| Message-ID: | 162867790912162148w39dbfc25g88f3efa17023a4ed@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/12/17 Erwin Brandstetter <brsaweda(at)gmail(dot)com>:
> On Dec 16, 10:47 pm, pavel(dot)steh(dot)(dot)(dot)(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A. Kretschmer | 2009-12-17 06:18:41 | Re: Fw: password authentication failed |
| Previous Message | Sam Jas | 2009-12-17 05:43:02 | Fw: password authentication failed |