Postgres: Table is shown using \d but shows syntax error while dropping the table

Question

I have weird issue when I do

`temp=# \d
                      List of relations
Schema |             Name              |   Type   |      Owner      
--------+-------------------------------+----------+-----------------
public | ORDER                         | table    | admin
public | ORDER_id_seq                  | sequence | admin `

As the table list as shown above. The table name ORDER is coming but when I try to drop it, I get the syntax error as
temp=# drop table ORDER; ERROR: syntax error at or near "ORDER" LINE 1: drop table ORDER;

What is the issue and what is other way to drop ORDER table?

Daniel Vérité · Accepted Answer · 2015-10-15 16:37:05Z

3

ORDER is a reserved keyword as mentioned in: http://www.postgresql.org/docs/current/static/sql-keywords-appendix.html

So it needs to be enclosed in double quotes when used as an object name. Besides, as it's in uppercase, even if it wasn't a keyword these double quotes would be needed anyway.

Just do:

drop table "ORDER";

answered Oct 15, 2015 at 16:37

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

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

Comments

jjanes · Accepted Answer · 2015-10-15 16:37:35Z

1

Since ORDER is also a SQL "reserved word", you have to put the table name in double quotes. (Which you have to do anyway because it is capitalized)

answered Oct 15, 2015 at 16:37

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Collectives™ on Stack Overflow

Postgres: Table is shown using \d but shows syntax error while dropping the table

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related