Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Question Unanswered: Reset All sequences

    Hi All,

    I have a postgre DB with many tables , and each table has its sequence .
    I have files contain sql statement to insert initial data into tables , and that insert statements inset IDs for the tables without using sequences ,so after I import the sql files , there will be data at tables , now if i want to insert new data I should reset all the sequences to start from the last id for each table, so how can i do that?
    plz help me.


  2. #2
    Join Date
    May 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts