copy command and blobs

From: Madhu Ramachandran <iammadhu(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: copy command and blobs
Date: 2011-01-20 20:12:48
Message-ID: AANLkTimGC+t9aADYn2KAXgqTMHwEoBV=Ht3iMV3dnxtZ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mladen Gogala 2011-01-20 20:17:24 Re: copy command and blobs
Previous Message Kevin Grittner 2011-01-20 17:04:59 Re: the XID question