Now a days it is common to use database as a service from cloud providers instead of maintaining the local postgres installation. Also there will be times you switch between providers due to some reason such as better cost or better performance. That time you may feel the need to install postgres client to back […]
Reset postgres sql auto increment key
Sometimes after you have imported data in to postgres sql database you might find the new inserts are failing as the generated unique sequence keys are conflicting with existing records. You could fix this by setting the new sequence value to the next values by checking the highest number already exists in records. Please run […]