\copy and identifier quoting - Mailing list pgsql-hackers

From Tom Lane
Subject \copy and identifier quoting
Date
Msg-id 14168.1034456262@sss.pgh.pa.us
Whole thread Raw
Responses Re: \copy and identifier quoting  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Isn't this a bug?

regression=# create table FOO (f1 int);
CREATE TABLE
regression=# \copy FOO from stdin
ERROR:  Relation "FOO" does not exist
\copy: ERROR:  Relation "FOO" does not exist
regression=#

This happens because \copy takes the given table name and slaps
double quotes around it, so the backend gets COPY "FOO" ...
rather than COPY FOO ...

It seems to me that psql's \copy should interpret the table name
the same way that a regular SQL command would: honor double quotes,
downcase in the absence of quotes.

Comments, objections?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: \copy needs work (was Re: Changing Column Order)
Next
From: Alvaro Herrera
Date:
Subject: Debugging bootstrap