Advanced Search

Return to Snippet

Revision: 63355
at April 30, 2013 20:56 by joaquimadraz
Initial Code 
WITH mx AS ( SELECT MAX(id) AS id FROM sch.mytable)
SELECT setval('sch.mytable_id_seq', mx.id) AS curseq
FROM mx;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
reset id sequence from postgres table

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
reset table id sequence

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL