Menu
Postgres 9.3.2 on heroku.
Pretty sure I'm just being an idiot, but I can't seem to figure out why my syntax is wrong.
db=> \dt List of relations Schema | Name | Type | Owner --------+------------+-------+---------------- public | device | table | admin public | post | table | admin public | user | table | admin (3 rows) // why does this fail? db=> drop table user; ERROR: syntax error at or near "user" LINE 1: drop table user; // does the right thing db=> drop table error; ERROR: table "error" does not exist 
807
You can remove table(s) from the database in PostgreSQL by using the statement DROP TABLE. It destroys the table with the indexes, rules, triggers, and constraints related to that table. The syntax is as follow: DROP TABLE [IF EXISTS] table_name [CASCADE | RESTRICT];
DROP TABLE department CASCADE; If a table is referenced by a view or a foreign key constraint, then use the CASCADE parameter to remove the dependent objects such as views, procedures, but in the case of the foreign key, it will just remove a foreign key constraint from a child table, not the child table itself.
The first method to remove a PostgreSQL database is to use the following SQL statement: DROP DATABASE <database name>; The command removes the directory containing the database information and the catalog entries. Only the database owner can execute the DROP DATABASE command.
DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is referenced by a view or a foreign-key constraint of another table, CASCADE must be specified.
User is a reserved keyword in Postgres. You'll have to put it in quotes if you want to refer to an actual table named user:
DROP TABLE "user";
Probably best to stay away from using reserved keywords as table names if you can help it. It usually ends up creating weird problems down the road. Users might be a better name for a table.
111
I had the same error. My database name was very unique and not a reserved keyword. Still needed to wrap the database name with quotation marks
"<database_name>"
Also for those that might forget always add a semicolon ; at the end of the statement, I always forget.
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
