Tag: postgresql

Safely increase size of a column in a PostgreSQL table without changing data

Sometimes we find that the size of a column is not sufficient to hold the data we need to store. We need to safely increase size of a column in a PostgreSQL table without changing data. Say, we have default

Posted in Postgres Tagged with: , , , , , , , , , ,

Execute .sql file from command line in postgresql

Hi all, Every now and then we have/want to run a .sql file or sql script from command line instead of typing each and every sql commands. So, I will write how to execute .sql file from command line in

Posted in Linux, Postgres, Ubuntu Tagged with: , , , , , , , , , , , , , , ,
%d bloggers like this: