When using COPY

From: "datactrl" <quals(at)bigfoot(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: When using COPY
Date: 2001-06-25 00:55:52
Message-ID: 005801c0fd11$9688e840$2400a8c0@hnjack
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Tille 2001-06-25 07:34:01 Foreign key problem
Previous Message Magnus Hagander 2001-06-23 16:39:07 RE: firehouse