Обсуждение: Novice

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

Novice

От
"Sugrue, Sean"
Дата:
Some of us have tried to use the COPY command to change tables instead of INSERT
because INSERT is slow,
but have had trouble because we're not super users. Is there a way around this?

Sean

Re: Novice

От
Tom Lane
Дата:
"Sugrue, Sean" <sean.sugrue@analog.com> writes:
> Some of us have tried to use the COPY command to change tables instead of INSERT
> because INSERT is slow,
> but have had trouble because we're not super users. Is there a way around this?

Use psql's \copy command ... not quite the same as COPY.

            regards, tom lane