I have this PostgreSQL table for storing words: CREATE TABLE IF NOT EXISTS words ( id bigint NOT NULL DEFAULT nextval('processed_words_id_seq'::regclass), keyword character varying(300) COLLATE pg_catalog."default", trademark_blacklisted character varying(300) COLLATE pg_catalog."default" ); insert into words (keyword,trademark_blacklisted) VALUES ('while swam is…
I need to make the connection with the PK from a table to its correspondent FK from another table. This is my db: I only have the case_id from the case table, and I need the case_uid from the case_test…
Let's say I have a view in which I am selecting the names of tables from a particular schema. How can I use SELECT so that it display the columns and its values from these tables? with tables_names as (…
I am writing a chat app and want to get a list of recent contacts to show in the sidebar. My table has the standard chat fields (sender, receiver, msg, date). I'm currently getting a list of recent contacts by…
I'm trying to create a small company database as a personal learning experience in PostgreSQL. I'm trying to follow Derek Banas tutorial (which is really helpful) but there is something different how my products are processed. So far I've made…
I'm trying to return one value for two conditions in SQL CASE statement CASE WHEN Col1 = 'false' OR Col1 IS NULL THEN 'NA' ELSE ... END Data Col1 ----- false poor moderate null In the query result, I'm getting…
I am creating a .NET target framework 7 Web API and I am trying to get data from a Postgresql function using Dapper, but I only get this error : 42601: syntax error at or near "getallvendormasternew" POSITION: 1 getallvendormasternew…
There is a table, has 10 million records, and it has a column which type is array, it looks like: id | content | contained_special_ids ---------------------------------------- 1 | abc | { 1, 2 } 2 | abd | { 1,…
I can do two select queries: select the top row customer_id select all rows that match the above customer_id But instead, I want to know if I can do the above in a single query? I know it's possible using…
I'm trying to update a jsonb array in Postgres by replacing the entire array. It's important to note, I'm not trying to add an array to the object, but simply replace the whole thing with new values. When I try…