Re: psql -f COPY from STDIN - Mailing list pgsql-sql

From Tom Lane
Subject Re: psql -f COPY from STDIN
Date
Msg-id 24757.1289660097@sss.pgh.pa.us
Whole thread Raw
In response to Re: psql -f COPY from STDIN  (Tarlika Elisabeth Schmitz <postgresql2@numerixtechnology.de>)
List pgsql-sql
Tarlika Elisabeth Schmitz <postgresql2@numerixtechnology.de> writes:
> I changed event.sql (3 lines):
> \COPY
>     (event_id, event_name)
>     FROM STDIN DELIMITER AS ',' NULL AS ''

> Now I am getting error messages:
> psql:event.sql:1: \copy:parse error at end of line

I don't believe you can split backslash commands across lines.

> When I remove the linefeeds I don't get errors but it does not import
> anything.

You wanted pstdin, not stdin.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tarlika Elisabeth Schmitz
Date:
Subject: Re: psql -f COPY from STDIN
Next
From: Tarlika Elisabeth Schmitz
Date:
Subject: Re: psql -f COPY from STDIN