This website works better with JavaScript
Home
Explore
Help
Register
Sign In
Apq
/
Masuit.MyBlogs
mirror of
https://gitee.com/masuit/Masuit.MyBlogs.git
Watch
1
Star
0
Fork
0
Files
Issues
0
Wiki
Tree:
300271b2c6
Branches
Tags
master
2025.10.18
2024.12.12
2024.11.13
2024.7.1
2023.11.17
2023.10.25
2023.4.8
2022.12.21
2022.10.6
2022.8.11
2022.6.10
2022.3.10
2021.12.29
v2021.12.0
v2021.10.8
2021.9.1
2021.7.27
2021.6.9
2021.5.8
2021.4.13
2021.3.10
2021.2.22
2020.12.9
2020.11.11
2020.9.29
2020.9.12
2020.5.28
2020.4.15
2020.3.8
2020.1.13
2019.11.06
3.1
3.0
2.0
1.0
Masuit.MyBlogs
/
database
/
postgres
懒得勤快
e1ac7a4d38
release
2 years ago
..
myblogs.7z
e1ac7a4d38
release
2 years ago
readme.txt
e1ac7a4d38
release
2 years ago
readme.txt
还原数据库后使用以下脚本生成重置id序列的sql:
SELECT concat('SELECT setval(''"',c.relname,'"'', MAX("',SPLIT_PART(c.relname, '_', 2),'")) FROM "',SPLIT_PART(c.relname, '_', 1),'";') FROM pg_class c WHERE c.relkind = 'S';