Обсуждение: When using COPY

Поиск
Список
Период
Сортировка

When using COPY

От
"datactrl"
Дата:
By using ...
COPY [ BINARY ] table [ WITH OIDS ]   FROM { 'filename' | stdin }   [ [USING] DELIMITERS 'delimiter' ]   [ WITH NULL AS
'nullstring' ]
 

[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