Loading different files

From: Sven Krosse <sven(dot)krosse(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Loading different files
Date: 2010-12-14 07:25:12
Message-ID: 4D071BD8.7080401@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-12-14 07:45:17 Re: Loading different files
Previous Message Sim Zacks 2010-12-14 07:17:44 crosstab function