copy command and blobs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux