I’m trying to get data from “users” table into ‘user_id’ and ‘profile_fullname’ rows from “profiles” table.

I wrote the code below in postgresSQL to create a table;

WITH limit_data AS ( SELECT l.amount, l.account, l.type, l.created_at, c.seller_id, c.verifier_id FROM limit l LEFT JOIN customer c ON l.account = c.customer_id WHERE l.type IN (‘MPESA_PREDICTED’, ‘PROPOSED_KENYA_AGENT’, ‘MPESA_AUTO’, ‘MPESA_CHECKED’, ‘MANUAL’) ) I tried querying data from the limit table and customer table and I was expecting to get the type, created at, amount and the […]

For Example i have Table T
T(A , B , C , D)

I’m creating a constraing in a table so that none of 8 columns must be equal to each other. I wanted to do:

I want to create a database to store forex exchange rates using this code into PostgreSQL:

I have a sql file , which extracts data from the db. For some reason it gives me this error:

I have multiple tables representing form options, from which I want to request the data as a JSON array of objects containing key-value pairs.

I am very new to using SQL or any coding for that matter so any advice would be appreciated!
I have wrote out an insert statement to insert data from mulitple times into a new table called detailed table. The query runs however it takes a while to complete (56 secs 106 msec)
I am wondering am i overcomplicating this query and if there is a simpler way to write this?

tengo un triger after insert el cual al dispararse ya debería tener los datos en la tabla pero me da error, ya que dentro del triger estoy haciendo una subconsulta que involucra la tabla asociada al triger que me devuelve null, a qué se debe esto?