Hello,
The intent is to use pdftotext and store the resulting text in datbase
for full text search purposes... I'm trying to develop a mini content
server where I'll put pdf documents to make it searchable.
Generally, PDFs are in size of 500 to 3000 pages resulting in text from
500kb to 2megabytes...
I'm also looking at open source projects like Alfresco if it can serve
with ease to my purpose... Anyone use this one? Comments are welcome.
Thanks
Bruno Lavoie
Sam Mason a écrit :
On Fri, Nov 07, 2008 at 11:15:43AM -0500, Bruno Lavoie wrote:
Is there a way to easily import a relatively huge text file into a table
column?
How big is "relatively huge"?
I'd like to use psql and I`'ve looked at lo_* commands and I
can't figure how to import my text file into my TEXT column.
the "lo_*" commands are for working with large objects; these have
somewhat unusual semantics compared to the normal data in columns in
PG. If you're routinely expecting files of more than, say, one MB then
they're probably a good way to go, but it's a lot more work getting them
going in the first place.
My last
solution is to write a little script to load my text file in a var and
then insert to databse.
If you want to just get the data into a TEXT column as quickly as
possible; I'd probably just write a little bit of code to perform the
escaping that PG requires on the file. You can then simply do:
COPY tbl (col) FROM '/path/to/escaped/file';
I'm not sure if this is really what you want though! "Enormous" TEXT
columns can be a bit fiddly to work.
Sam
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
