pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: datactrl <quals@bigfoot.com>
To: pgsql-sql@postgresql.org
Subject: When using COPY
Date: Mon, 25 Jun 2001 10:55:52 +1000
Message-ID: <005801c0fd11$9688e840$2400a8c0@hnjack> (raw)

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




Message-ID: <005801c0fd11$9688e840$2400a8c0@hnjack>
Permalink:  ../005801c0fd11$9688e840$2400a8c0@hnjack/
Also on:    postgresql.org/message-id/005801c0fd11$9688e840$2400a8c0@hnjack

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: quals@bigfoot.com
  Subject: Re: When using COPY
  In-Reply-To: <005801c0fd11$9688e840$2400a8c0@hnjack>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox