Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5P0vca99360 for ; Sun, 24 Jun 2001 20:57:38 -0400 (EDT) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f5P0vV825179 for ; Mon, 25 Jun 2001 10:57:33 +1000 Received: from bri4-56k-022.tpgi.com.au(202.7.185.22), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpd1Tif56; Mon Jun 25 10:57:24 2001 Message-ID: <005801c0fd11$9688e840$2400a8c0@hnjack> From: "datactrl" To: Subject: When using COPY Date: Mon, 25 Jun 2001 10:55:52 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/393 X-Sequence-Number: 3690 By using ... COPY [ BINARY ] table [ WITH OIDS ] FROM { 'filename' | stdin } [ [USING] DELIMITERS 'delimiter' ] [ WITH NULL AS 'null string' ] [BINARY]: If I use it instead of choosing a delimiter, is that safe for copied data and more quick to copy? [WITH OIDS] : If my application didn't use any oid, do I need to specify it? Which one (specify it or not ) will be more quick to copy? THANK YOU JACK