postgresql Archives - Page 4 of 21

postgresql, Programming

IT Nursery

PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values

When you are upserting a row (PostgreSQL >= 9.5), and you want the possible INSERT to be exactly the same as the possible ...

May 31, 2022
0 Comments

postgresql, Programming

IT Nursery

Why does PostgreSQL perform sequential scan on indexed column?

Very simple example – one table, one index, one query: CREATE TABLE book ( id bigserial NOT NULL, "year" integer, -- other columns... ...

May 30, 2022
0 Comments

datetime, Programming

IT Nursery

How do I convert an interval into a number of hours with postgres?

Say I have an interval like 4 days 10:00:00 in postgres. How do I convert that to a number of hours (106 in ...

May 30, 2022
0 Comments

Programming, Python

IT Nursery

psycopg2: insert multiple rows with one query

I need to insert multiple rows with one query (number of rows is not constant), so I need to execute query like this ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Are PostgreSQL column names case-sensitive?

I have a db table say, persons in Postgres handed down by another team that has a column name say, "first_Name". Now am ...

May 29, 2022
0 Comments

linux, Programming

IT Nursery

How to configure postgresql for the first time?

I have just installed postgresql and I specified password x during installation. When I try to do createdb and specify any password I ...

May 29, 2022
0 Comments

Programming, sql

IT Nursery

PostgreSQL wildcard LIKE for any of a list of words

I have a simple list of ~25 words. I have a varchar field in PostgreSQL, let’s say that list is...

May 29, 2022
0 Comments

Database, Programming

IT Nursery

Connect to a heroku database with pgadmin

I would like to manage my Heroku database with pgadmin client. By now, I’ve been doing this with psql. When I use data ...

May 29, 2022
0 Comments

postgresql, Programming

IT Nursery

PostgreSQL ERROR: canceling statement due to conflict with recovery

I’m getting the following error when running a query on a PostgreSQL db in standby mode. The query that causes the error works ...

May 29, 2022
0 Comments

postgresql, Programming

IT Nursery

How to perform update operations on columns of type JSONB in Postgres 9.4

Looking through the documentation for the Postgres 9.4 datatype JSONB, it is not immediately obvious to me how to do updates on JSONB ...

May 29, 2022
0 Comments