Re: [GENERAL] Importing text file into a TEXT field

2008-11-10 Thread Adriana Alfonzo
no quiero recibir mas correos de estos temas en donde no estoy incluida, gracias. Bruno Lavoie escribió: Hello Thomas, nice tool! Thanks for your help... For batch and automation purposes, I've done a small script... (check out my last post in the thread few minutes ago) Bruno Lavoie Th

Re: [GENERAL] Importing text file into a TEXT field

2008-11-10 Thread Bruno Lavoie
Hello Thomas, nice tool! Thanks for your help... For batch and automation purposes, I've done a small script... (check out my last post in the thread few minutes ago) Bruno Lavoie Thomas Kellerer a écrit : Bruno Lavoie, 07.11.2008 19:20: Hello, The intent is to use pdftotext and store th

Re: [GENERAL] Importing text file into a TEXT field

2008-11-10 Thread Bruno Lavoie
Hello Sam, Thanks for your Python script! It's on my todo list to learn this scripting language. I've done a mini script in Perl for my testing purposes and then test full text search! Here is my table definition: test1=# \d pdfsys.document; Table "pdfsys.document" Column

Re: [GENERAL] Importing text file into a TEXT field

2008-11-10 Thread Thomas Kellerer
Bruno Lavoie, 07.11.2008 19:20: 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 resu

Re: [GENERAL] Importing text file into a TEXT field

2008-11-10 Thread Sam Mason
On Fri, Nov 07, 2008 at 01:20:27PM -0500, Bruno Lavoie wrote: > 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. I've not tried to do this so

Re: [GENERAL] Importing text file into a TEXT field

2008-11-07 Thread Bruno Lavoie
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 2meg

Re: [GENERAL] Importing text file into a TEXT field

2008-11-07 Thread Sam Mason
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

[GENERAL] Importing text file into a TEXT field

2008-11-07 Thread Bruno Lavoie
Hello, Is there a way to easily import a relatively huge text file into a table column? 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. My last solution is to write a little script to load my text file in a var and then