954
社区成员
发帖
与我相关
我的任务
分享Postgre中Drop表时报错，请指教。（在线等，做答结贴）
hsbpt=# \d
List of relations
Schema | Name | Type | Owner
--------+------------------+----------+-------
public | order | table | hsbpt
public | order_field1_seq | sequence | hsbpt
(2 rows)
hsbpt=# drop table order cascade;
ERROR: parser: parse error at or near "order" at character 12
hsbpt=#
List of relations
Schema | Name | Type | Owner
--------+------------------+----------+-------
public | order | table | hsbpt
public | order_field1_seq | sequence | hsbpt
(2 rows)
hsbpt=# drop table order cascade;
ERROR: parser: parse error at or near "order" at character 12
hsbpt=#
...全文
请发表友善的回复…
发表回复
seawolfzxw 2004-04-24
- 打赏
- 举报
谢谢两位
sunthing 2004-04-23
- 打赏
- 举报
对，应该就是楼上的原因
santest=# drop table testid cascade ;
DROP TABLE
santest=#
但要用双引号：
santest=# drop table "user" cascade ;
DROP TABLE
santest=#
santest=# drop table 'atest' cascade ;
ERROR: parser: parse error at or near "'atest'" at character 12
santest=#
santest=# drop table testid cascade ;
DROP TABLE
santest=#
但要用双引号：
santest=# drop table "user" cascade ;
DROP TABLE
santest=#
santest=# drop table 'atest' cascade ;
ERROR: parser: parse error at or near "'atest'" at character 12
santest=#
younker 2004-04-22
- 打赏
- 举报
order is the sql keyword, maybe you need a single quoter to quote it
postgre利用pagehelper分页查询报错ERROR: LIMIT #,# syntax is not supported 建议：Use separate LIMIT and OFFSET c
