I’m using Postgresql 16.3 but whenever I try to import a new file (.sql) it doesn’t work! I tried to import my .sql file using Postbird, but it throws me an error that says: “psql authentification method 10 not supported FAILURE”

CREATE SEQUENCE IF NOT EXISTS public.lntds_asset_notes_id_seq
INCREMENT 1
START 1
MINVALUE 1
MAXVALUE 2147483647
CACHE 1;

I have a PostgreSQL query that aggregates data from multiple tables and generates a report. Currently it works perfectly fine and it is quite simple. Here is the query I’m using:

The manual says:

on the docs says:

I have a table that Postgres is really struggling with planning queries on. I’ve been running:

There is a database with online store customers, which has the following data:

How can I share a temp table between transactions on Postgresql?

I need to select all records except those whose field “ver_card_id” matches and field “answer” differs, and one of the values ​​must be 5
[Help]
(https://i.sstatic.net/VnjTXJth.png)

Lets say I have 2 functions: get_emp_ids and get_emp_details on my employees table. The get_emp_ids function returns a refcursor containing the ids of the employees. This will be function that will be frequently called in other procedures/functions.