postgresql Archives - IT Nursery

postgresql, Programming

IT Nursery

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 ...

June 4, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 4, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 3, 2022
0 Comments

postgresql, Programming

IT Nursery

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? ...

June 3, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 2, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 2, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

June 1, 2022
0 Comments

postgresql, Programming

IT Nursery

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, ...

June 1, 2022
0 Comments

postgresql, Programming

IT Nursery

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 ...

May 31, 2022
0 Comments