On Dec 16, 2009, at 11:19 AM, Erwin Brandstetter wrote:
> Hello,
>
> I need a long text form from a file in my plpgsql variable.
> Can anyone think of a more straightforward way to read the file than
> the following:
>
>
> CREATE FUNCTION test() RETURNS void AS
> $BODY$
> DECLARE
>
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
NotDashEscaped: You need GnuPG to verify this message
> I need a long text form from a file in my plpgsql variable.
> Can anyone think
2009/12/17 Erwin Brandstetter :
> 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
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 i
hello
look on orafce from pgfoundry. There modul utl_file
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29#UTL_FILE
Regards
Pavel Stehule
2009/12/16 Erwin Brandstetter :
> Hello,
>
> I need a long text form from a file in my plpgsql variable.
> Can anyone think of a more st
Hello,
I need a long text form from a file in my plpgsql variable.
Can anyone think of a more straightforward way to read the file than
the following:
CREATE FUNCTION test() RETURNS void AS
$BODY$
DECLARE
mytxt text;
BEGIN
CREATE TEMP TABLE x (x text);
COPY x from '/path/to/myfi
