Psql could not connect to server: No such file or directory, 5432 error?
I’m trying to run psql on my Vagrant machine, but I get this error: psql: could not connect to server: No such file … Read more
postgresql
How do I temporarily disable triggers in PostgreSQL?
I’m bulk loading data and can re-calculate all trigger modifications much more cheaply after the fact than on a row-by-row basis. How can … Read more
How to add column if not exists on PostgreSQL?
Question is simple. How to add column x to table y, but only when x column doesn’t exist ? I found only solution … Read more
PostgreSQL: role is not permitted to log in
I have trouble connecting to my own postgres db on a local server. I googled some similar problems and came up with this … Read more
Truncating all tables in a Postgres database
I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this directly in SQL? … Read more
Which data type for latitude and longitude?
I am newbie to PostgreSQL and PostGIS. I want to store latitude and longitude values in PostgreSQL 9.1.1 database table. I will calculate … Read more
Change type of varchar field to integer: “cannot be cast automatically to type integer”
I have a small table and a certain field contains the type “character varying“. I’m trying to change it to “Integer” but it … Read more
How do you find the disk size of a Postgres / PostgreSQL table and its indexes
I’m coming to Postgres from Oracle and looking for a way to find the table and index size in terms of bytes/MB/GB/etc, or … Read more
Tools to generate database tables diagram with PostgreSQL? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, … Read more
How to get min/max of two integers in Postgres/SQL?
How do I find the maximum (or minimum) of two integers in Postgres/SQL? One of the integers is not a column value. I … Read more