psql \copy command runs as a transcation?

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: psql \copy command runs as a transcation?
Date: 2007-08-27 01:52:32
Message-ID: 1188179552.7562.2.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Does the psql's \copy command run as a transaction? I think it does, but
somehow when I cancel (in a script) a running import, "seems" (I can't
seem to duplicate it on the cli though) like a few lines/rows gets
inserted anyway..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-08-27 02:34:30 Re: SQL Diff ?
Previous Message Gregory Stark 2007-08-27 01:05:06 Re: Restore v. Running COPY/INDEX seperatly