PostgreSql 复制表语法
问题:有一张表cq_question_answer中的部分数据需要修改,但是表中的数据量很大,所以我想借助临时表来操作。
所以我采用MySQL常用的复制表的语法(如下)来生成一张与cq_question_answer结构相同的临时表cq_question_answer_temp:
CREATE TABLE cq_question_answer_temp like cq_question_answer;
结果运行sql报错,错误信息:
[SQL]CREATE TABLE cq_question_answer_temp like cq_question_answer;
[Err] ERROR: syntax error at or near "like"
LINE 1: CREATE TABLE cq_question_answer_temp like cq_question_answer...
^
说在"like"附近有语法错误,所以我换另一种写法试试:
CREATE TABLE cq_question_answer_temp SELECT * FROM cq_question_answer WHERE 1 = 2;
运行结果还是出错,跟上面的错误一样:
[SQL]CREATE TABLE cq_question_answer_temp SELECT * FROM cq_question_answer WHERE 1 = 2;
[Err] ERROR: syntax error at or near "SELECT&