PgSQl临时表的创建
创建前可先删除
drop table tmp0
创建临时表
select * into temp table tmp0 from xxx create index idx_tmp0_inner_cd on tmp0(inner_cd);
查看临时表是否创建，返回0表⽰未创建，1为创建
select count(*) from pg_class where relname = 'tmp0'
或者⽤下⾯，下⾯语句在pg和mysql中都适⽤
Create Table If Not Exists temp.MyTable(xxx varchar (20) Primary key ,thTime varchar (20) ,name varchar (20))
同样可以⽤在删除表中：
DROP TABLE If Exists temp.mjp_temp_update_log
应⽤例⼦：
SELECT ids, code,
INTO TEMP TABLE tmp0FROM
TEMP .m_product_xWHERE
TEMP .m_product_x.ids = ''GROUP BY
TEMP .m_product_x.code, TEMP .m_product_x.ids;
CREATE INDEX idx_tmp0_inner_cd ON tmp0 (code);SELECT*
FROM
TEMP .m_product
INNER JOIN tmp0 ON TEMP .m_product.code = tmp0.codeWHERE
TEMP .m_product.ids = ''ORDER BY tmp0.xx, tmp0.ss;
DROP TABLE tmp0;