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 <brsaweda@xxxxxxxxx>: > 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/myfile.txt'; > mytxt := (SELECT x from x); > > ... > > END; > $BODY$ > LANGUAGE 'plpgsql' VOLATILE; > > > > Regards > Erwin > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
