I recently installed Postgresql 16, during the installation one window came up showing that I need to put two same passwords for postgres, so I just put 4 numbers and hit next,
Here is the image

I build postgresql by docker compose and I can not create extension vector.

Table

I am trying send data from csv to postgres table. I am getting the import successful message but the data is not to inserted in the table. What could be the issue?

I have a jsonb[] column in my table named jsonb_column, which contains an array of JSONB objects. For example:

I have a database table invoices, the table contains three fields id auto incremented, created_at and invoice_id, I want to make the invoice_id so that each day or each time the user needs to reset the invoice_id, it start from 1 again.