Re: Importing text file into a TEXT field

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