Loading different files - Mailing list pgsql-general

From Sven Krosse
Subject Loading different files
Date
Msg-id 4D071BD8.7080401@googlemail.com
Whole thread Raw
Responses Re: Loading different files  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Dear all,

I am looking for a mechanism to load a specific file into an existing
database. The file is a CTM (Compact Topic Maps Syntax ) file and I have
written a CTM parser in plpgsql which works fine. The main problem is,
that I have to load the file into memory and sent a query to database
which causes an memory error because of a hugh file size. Is it possible
to copy data from a file into database by using own functions?

Thanks for response.


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: crosstab function
Next
From: John R Pierce
Date:
Subject: Re: Loading different files