in posgresql how do I reset sequence? (I got to 5046 and it looks ugly)
Why would you want to reset a sequence? Sequences should be used for internal ids. So that you can uniquely identify a record for queries and foreign key relationships. It's appearance shouldn't be a factor you want them to be unique.
Nope, it's not needed but if you can't handle the ugliness -
select setval('my_sequence', NULL, 'false')
Thing is I have deleted all records from my db and I want to reset ids since I use them in forms I submit and since Im at the moment tweaking my system it is much easier to remember 10 then 12753
