Re: using COPY table FROM STDIN within script run as psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: using COPY table FROM STDIN within script run as psql
Date: 2004-09-27 17:53:35
Message-ID: 2757.1096307615@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> writes:
> I can reproduce the problem with this command:

> psql -U egenome_test -P pager=off -f
> /Users/murphy/cvs/egora/sql/data_build/junk.sql < ./junk.dat

> with junk.sql and junk.dat as follows:

> COPY import_sts_tmp FROM STDIN WITH NULL AS '';

This command says to copy from the SQL script file. You can use
psql's \copy command to get the effect you are after.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2004-09-27 18:08:03 Re: using COPY table FROM STDIN within script run as psql
Previous Message Kevin Murphy 2004-09-27 17:38:53 Re: using COPY table FROM STDIN within script run as psql