postgres database column name not recognized

Question

I'm using postgresql database, in a table, I have a column named date. The problem occurs when I try making some operations with this column (date).

For example:

create index tg_index ON table_replay using btree(date);

here is my error:

ERROR: column "date" does not exist

****** Error ******

ERROR: column "date" does not exist SQL state: 42703

PS: I cannot change this column name because this is a big database so i need many years to perform any change. Thanks for understanding.

date is a reserved word (type name) in SQL. Use double quotes if you insist on using at as a column name : USING BTREE("date" ) (and tell the person who designed the DB that date is a bad name) BTW: if you can create an index, you can probably rename the column, too — joop
– joop, Commented May 23, 2014 at 10:37
This database is not mine, but cause of latency, I have to migrate it on postres database (It's actually on MySql). There are many reasons that I cannot change this column name. This may cause a "Big Bug" on our system (witch is designed by another person). That's way I try to find solution without change the column name. — mdlx
– mdlx, Commented May 23, 2014 at 16:22

Ankit Bajpai · Accepted Answer · 2014-05-23 10:44:19Z

1

Change your column name from date to another such as date because date is a reserved word. You can easily achieve this by using alter commmand. Using alter command dosen't take too much time because alter command only affects the table structure reather than the data of the table. alter command have no concern with the data of the table.

answered May 23, 2014 at 10:44

Ankit Bajpai

13.6k4 gold badges27 silver badges43 bronze badges

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

Comments

websterridge · Accepted Answer · 2014-05-23 10:43:17Z

1

http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html says date is a reserved keyword. You can try quoting it. That may not work.

I agree witht he above comment - use of plain keywords that have a generic sense is generally a bad practice - column names should help to describe the purpose of the column.

answered May 23, 2014 at 10:43

websterridge

3691 silver badge5 bronze badges

Collectives™ on Stack Overflow

postgres database column name not recognized

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related