PostgreSQL Can't do simple query after use copy function

Question

I'am using PostgreSQL and PHPPgAdmin. I have data in the file ext.csv, and I'm using the COPY function to import the data. I have already made a table with 15 columns and imported my data.csv to this table via function copy.

The problem is that I can't identify my column table with query. For example:

select customer_name from gis

produces the error:

Query failed: ERROR: column "customer_name" does not exist LINE 1

Why this happen? I also checked in PHPPgAdmin and there the gis has a column and data.

Suggestions?

Are you using a different schema from public in the database ? — tftd
– tftd, Commented Jun 26, 2013 at 2:04
Details? Are you setting search_path? What's the output of \d gis in the psql client? PostgreSQL version? — Craig Ringer
– Craig Ringer, Commented Jun 26, 2013 at 2:05

Craig Ringer · Accepted Answer · 2013-06-26 02:04:43Z

2

I'm going to guess that you capitalized the column name when creating it, eg "Customer_Name".

If so, you must "double quote" it where you refer to it elsewhere.

answered Jun 26, 2013 at 2:04

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Krichevskoy Over a year ago

thanks so much craig ringer, i try to alter table the column, and now it's work. Best Regard.

Craig Ringer Over a year ago

@user2522265 So - was it a case sensitivity problem? stackoverflow.com/help/someone-answers . In future, please show \d output from psql for the relevant tables - and include your exact PostgreSQL version in all questions.

Collectives™ on Stack Overflow

PostgreSQL Can't do simple query after use copy function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related