Re: COPY seems to work, but no data in the table

From: nconway(at)klamath(dot)dyndns(dot)org (Neil Conway)
To: Brian Dougherty <briand(at)veridicom(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY seems to work, but no data in the table
Date: 2002-07-16 16:25:06
Message-ID: 20020716162506.GB27614@klamath.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 15, 2002 at 07:36:58PM -0700, Brian Dougherty wrote:
> I executed a successful COPY, or at least psql responded "COPY", but
> when I looked at the table with SELECT *, no rows were found.
>
> What's going on there?

Can you give us a full example? For instance, the definition of the
table, the command you're using to COPY in data, and a sample of
the source data.

Cheers,

Neil

--
Neil Conway <neilconway(at)rogers(dot)com>
PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnson, Shaunn 2002-07-16 16:30:55 integer out of range errors
Previous Message Stephan Szabo 2002-07-16 16:23:31 Re: Constraint