Thread: Novice

Novice

From
"Sugrue, Sean"
Date:
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

From
Tom Lane
Date:
"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