Thread: Port Bug Report: Has ceased to work the command "copy" from shell

Port Bug Report: Has ceased to work the command "copy" from shell

From

Unprivileged user

Date:

14 June 1999, 18:02:00

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               : Mike L. Rogalsky
Your email address      : autoinfo@auto.ru

Category                : unknown
Severity                : non-critical

Summary: Has ceased to work the command "copy" from shell

System Configuration
--------------------
  Operating System   : FreeBSD 2.2.5-RELEASE

  PostgreSQL version : 6.5

  Compiler used      : 2.7.2.1

Hardware:
---------


Versions of other tools:
------------------------


--------------------------------------------------------------------------

Problem Description:
--------------------
I frequently use the "copy" command for fast loading of data in base.

In a batch file I write the command:
/usr/local/pgsql/bin/psql -q -d auto -f zapros.sql < model.out

zapros.sql contains the command:
COPY model FROM STDIN USING DELIMITERS '|';

Model.out contains loaded data.
Up to version 6.4.2 it worked correctly.
Now does not work...

--------------------------------------------------------------------------

Test Case:
----------


--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------