Re: COPY doesn't like my dates on STDIN

My bad, I apologize. The error was not being thrown by the
COPY statement, but by a later INSERT.

The syslog showed me this:

Mar 18 22:32:02 ns postgres[70347]: [6-1] ERROR: syntax error at or near "2008" at character 1
Mar 18 22:32:02 ns postgres[70347]: [6-2] STATEMENT: 2008-03-18
Mar 18 22:32:02 ns postgres[70347]: [6-3] insert into table_name
Mar 18 22:32:02 ns postgres[70347]: [6-4] select * from temp_table;

I thought that INSERT would match up like-named fields, but
it appears to match fields up in the order they appear in
the schema. If suppose to match up like names, one
must specify the ( field, names ) in the INSERT and SELECT
statements.

Jim

On Tue, Mar 18, 2008 at 08:31:41PM -0700, James Long wrote:
> I'm trying to
>
> copy temp_table ( id, date_created ) from stdin;
> TME 2008-03-18
> \.
>
> pgsql says:
>
> ERROR: column "date_created" is of type date but expression is of type character
> HINT: You will need to rewrite or cast the expression.
>
> I basically grok what it is saying, but the "expression" is in the
> STDIN stream. How do I cast that? And I also don't get why my
> pg_dump backup scripts use this same syntax but I can't.
>
> One such pg_dump-created file says:
>
> COPY tickets (ticket_number, reservation_number, travel_date, issue_date, ... )
> FROM stdin;
> 2115492091826 11ACFD 2006-08-28 \N ...
>
> Certainly, no criticism intended. I really enjoy PG. Just
> confusion on my part is all.
>
> Thank you,
>
> Jim
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice