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