I run the following to start a postgres server container: docker run --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres What I was expecting was to use dbeaver to connect via localhost:5432 with postgres and mysecretpassword, but I keep getting the following…
I got a files table: CREATE TABLE files ( id SERIAL PRIMARY KEY, path VARCHAR NOT NULL UNIQUE ); And I wanna write an sql transaction to emulate FS behavior when you tryna create a file: if a file with…
I have a function in PL/pgSQL that accepts a record type parameter, and returns 1 record type as well: DROP FUNCTION IF EXISTS public.f_obtem_record_auth(record); CREATE OR REPLACE FUNCTION public.f_obtem_record_auth( rec RECORD -- trabalhar com apenas um aparametro do tipo record…
I am clear on how GROUPING SETS (and ROLLUP and CUBE) work for a single expression. However, I've never entirely understood how it works when multiple GROUPING SETS are combined. Here is an example table that I've created to help…
I have a cookiecutter django template project working fine with a local postgres database. (https://cookiecutter-django.readthedocs.io/en/latest/) I've copied the git repository and recreated the docker images on a new host to run in production, but I would like to export/copy my…
I have two tables T1 and T2. I'm doing a simple inner join select t1.a, t1.b, t1.c from T1 t1 inner join T2 t2 on t1.c = t2.c Table T1 has got 2 million rows and T2 has got 4…
I have the task of matching two lists of names and addresses - represented in two database tables in PostgreSQL. Address data can be strings like Otto-Johannsen-Straße 7 or even Otto-Johannsen-Str. 7 Wohnung oben which have to match to Otto-Johannsen-Str.…
What I am trying to do is to calculate the sum of the 2 tableSpaces I have in my PostgreSQL DB. SELECT pg_size_pretty (pg_tablespace_size ('pg_default') ); with this query I am able to find the used space but when I…
In PostgreSQL (I use 14 and 16) I am trying to create a function that inserts a record into a table that has two columns: an identifier (integer) and a string "Some string". I want to write a loop to…
I am receiving this error message. ERROR: there is no unique constraint matching given keys for referenced table "Employees" This is what I have run: -- Exported from QuickDBD: https://www.quickdatabasediagrams.com/ -- Link to schema: https://app.quickdatabasediagrams.com/#/d/Sa6Ijr -- NOTE! If you have…