postgresql Archives - Page 11 of 21

How to check if a service that I don’t know the name of is running on Ubuntu

I do not know the service’s name, but would like to stop the service by checking its status. For example, if I want ...

May 19, 2022
0 Comments

ERROR: permission denied for sequence cities_id_seq using Postgres

I’m new at postgres (and at database info systems all in all). I ran following sql script on my database: create table cities ...

May 19, 2022
0 Comments

PostgreSQL: Give all permissions to a user on a PostgreSQL database

I would like to give a user all the permissions on a database without making it an admin. The reason why I want ...

May 19, 2022
0 Comments

How to find duplicate records in PostgreSQL

I have a PostgreSQL database table called “user_links” which currently allows the following duplicate fields: year, user_id, sid, cid The unique constraint is ...

May 19, 2022
0 Comments

PostgreSQL DISTINCT ON with different ORDER BY

I want to run this query: SELECT DISTINCT ON (address_id) purchases.address_id, purchases.* FROM purchases WHERE purchases.product_id = 1 ORDER BY purchases.purchased_at DESC But ...

May 19, 2022
0 Comments

Postgres manually alter sequence

I’m trying to set a sequence to a specific value. SELECT setval('payments_id_seq'), 21, true This gives an error: ERROR: function setval(unknown) does not ...

May 19, 2022
0 Comments

Backup/Restore a dockerized PostgreSQL database

I’m trying to backup/restore a PostgreSQL database as is explained on the Docker website, but the data is not restored. The volumes used ...

May 18, 2022
0 Comments

How to list active connections on PostgreSQL?

Is there a command in PostgreSQL to select active connections to a given database? psql states that I can’t drop one of my ...

May 18, 2022
0 Comments

In Postgresql, force unique on combination of two columns

I would like to set up a table in PostgreSQL such that two columns together must be unique. There can be multiple values ...

May 18, 2022
0 Comments

How to set auto increment primary key in PostgreSQL?

I have a table in PostgreSQL with many columns, and I want to add an auto increment primary key. I tried to create ...

May 18, 2022
0 Comments