Shulou(Shulou.com)06/01 Report--

Change the self-incrementing id of the postgresql data table

First look at the index name of the self-incrementing ID that needs to change the table:

Use the command:\ d you_table_name

As shown in the figure below, server_server_id_seq is the index of the self-incrementing ID in the Default column:

Use sql to update the self-incrementing ID, using the largest ID value in the database table as the self-incrementing ID value, as shown below:

Select steval ('you_table_id_seq', (select max (you_table_id) from you_table_name))

The example is as follows:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.