copy command and blobs - Mailing list pgsql-performance

From Madhu Ramachandran
Subject copy command and blobs
Date
Msg-id AANLkTimGC+t9aADYn2KAXgqTMHwEoBV=Ht3iMV3dnxtZ@mail.gmail.com
Whole thread Raw
Responses Re: copy command and blobs  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
List pgsql-performance
hello,

i have a table with OID column.. I want to use the copy command to insert bunch of rows (1 million).
but iam unable to specify the correct format for the oid type (i have .jpg files to be stored in this column)..

I tried giving the path to the file, lo_import('pathto file').. appreciate any tips.. i did search the archives , but couldnt find any answer on this

Thanks again

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: the XID question
Next
From: Mladen Gogala
Date:
Subject: Re: copy command and blobs