There is nothing here and it is completely bug free

Articles with the postgresql tag

Copy DB in PostgreSQL

Sometimes I need a way to manipulate my database but I dont want to fuss with my main data. So here is a quick way to copy a database: create database with template owner ;

PSQL: Add constraints to existing table

While working on a product at some point we had a bad import of data. Unfortunately it was so straight forward to get the data back and the data that we DID import did not come with all the constraints that the original had. Here is how I added them ...