Redshift截断表并重置身份? [英] Redshift Truncate table and reset Identity?

问题描述

我知道在PostgresQL中有

I know in PostgresQL there is

truncate table restart identity;

，但这在Redshift中不起作用.在Redshift中还有其他要做的事情吗?否则，删除表并重新创建和加载会很麻烦.

but this doesn't work in Redshift. Is there something else to do this in Redshift? Otherwise I see it lot of pain to drop table and recreate and load.

推荐答案

不可能像其他sql数据库一样在redshift中重新设置标识值.您必须创建新表并将数据移到那里.

Its not possible to reseed identity value in redshift like other sql databases. you have to create new table and move data there.

这篇关于Redshift截断表并重置身份?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！