If you’ve ever needed to “reset” the auto-incrementing row ID in a Postgres database here is a simple command to start fresh (this should work for any SQL based DB really). Typically during the development life cycle I want to generate new dummy data for testing purposes. Sometimes …

If you’re using Postgres as a database and need to import data from a .csv file, it’s really easy to do using psql. Before you start, you’l need: psql running in an interactive terminal A Postgres database with a table you want to import data, we’ll call it user_data Data in …