Postgresql – SQL to get json output in Postgres
HI Team am trying to generate output from a table but tried unable to get it. create table t1(a int, b int, c text); insert into t1 values (1, 1, 'm'); insert into t1 values (1, 2, 'm'); insert into…
Docker container fails to connect to psql. psql: could not connect to server. docker compose
I need to import the schema into the db in the container and, I already had this whole thing going, imported the db schema, made sure the app is up and running and made a commit and had started working…
Postgresql – Can't get Django to use Postgres
I am trying to switch a local Django project from the default sqlite3 database to a postgres v.14 database. I've been through several tutorials but nothing seems to work and I'm not sure what I'm doing wrong. Steps I've performed:…
Postgresql – How to make a table with count of each category
I have a table with two columns. One is Name, other is Mark. Mark can be low, mid or high. Under every name, i want count of high low and mid. enter image description here
Postgresql – Postgres, Insert into many values with select
This is my first post here so please accept my apologies in advance if anything is out of place. I have table "Users", for each user there is a statement about whether he participates in promotions "IsParticipates", this is one…
Postgresql – Update json field in postgres table
I'm trying to add even more key : value data to existing json data. I get data from postgres with a query to the field and get a dictionary. After that, I simply add an additional key-value pair to the…
Telegram – Write a trigger that accepts a user_id
When creating a new user in Postgres, I have a trigger that automatically creates a chat for him (like saved messages in telegram). I also have a chat_members table in the database that stores chat members in a many-to-many relationship…
Installing Postgres in Ubuntu VM
I have installed Postgres on my UBUNTU VM. prompt$ sudo -u postgres psql and entered my linux password. I am getting the message: could not change directory to "/home/petroman": Permission denied psql (15.4 (Ubuntu 15.4-1.pgdg22.04+1)) Type "help" for help. postgres=#…
Sqlx: Convert / Retrieve Postgresql column of type RECORD[] into a struct field of type Vec<_>
I have the following two structs: #[derive(Serialize, Deserialize)] struct Login { email: String, oidc_id: String } #[derive(Serialize, Deserialize)] struct Account { id: Uuid, created: NaiveDateTime, private_key: String, public_key: String, logins: Vec<Login> } I want to use them to read data…
Postgresql – How to initialize a rowtype array in pl/pgsql?
I need to declare an array of records that will be inserted into some table then. But i cannot find a way to initialize this array. Like, for table like this: create table mytable ( id serial, value varchar );…