Postgres Pro
Downloads
Home   >   mailing lists

Re: copy command and blobs - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: copy command and blobs
Date
Msg-id 4D389854.80603@vmsinfo.com
Whole thread Raw
In response to copy command and blobs  (Madhu Ramachandran <iammadhu@gmail.com>)
Responses Re: copy command and blobs  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: copy command and blobs  (Madhu Ramachandran <iammadhu@gmail.com>)
List pgsql-performance
Tree view 
Madhu Ramachandran wrote:
> 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)..
Huh? oid is a keyword, an automatically generated row id, and is
deprecated. You shouldn't be doing anything with it, much less copying it.


--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions

pgsql-performance by date:

Previous
From: Madhu Ramachandran
Date:
Subject: copy command and blobs
Next
From: Tom Lane
Date:
Subject: Re: copy command and blobs