Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY seems to work, but no data in the table - Mailing list pgsql-general

From nconway@klamath.dyndns.org (Neil Conway)
Subject Re: COPY seems to work, but no data in the table
Date
Msg-id 20020716162506.GB27614@klamath.dyndns.org
Whole thread Raw
In response to COPY seems to work, but no data in the table  (briand@veridicom.com (Brian Dougherty))
List pgsql-general
Tree view 
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@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Constraint
Next
From: "Johnson, Shaunn"
Date:
Subject: integer out of range errors