I use DBSCHEMA tool and want to execute a query but I got this error: syntax error at or near "id" position 209 Code: CREATE TABLE user_info ( id UUID PRIMARY KEY, full_name VARCHAR NOT NULL, birthday VARCHAR NOT NULL,…
I have a Postgres table named "base" with a jsonb field called "addresses" which stores multiple addresses for the same user. Here is the table structure: create table base(name text, addresses jsonb); insert into base(name, addresses) values('John', '[{"zip":"01431000","state":"SP","number":100,"street1":"Avenida Brasil","city_name":"São Paulo"},{"zip":"01310900","state":"SP","number":200,"street1":"Avenida…
Let's say we have a table called 'grouper' id column_a 1 value 2 value And a table called 'translation' that contains following columns id locale text grouper_id 1 en some en text 1 2 es some es text 1 3…
I am using the following query to insert data to PostgreSQL tables user and password. BEGIN; INSERT INTO users (user_id, user_username, user_name, user_surname) VALUES (?, ?, ?, ?); INSERT INTO passwords (user_id, user_password) VALUES (?, ?); COMMIT; I would like…
So optimized a sql server proc recently. Went from this select id, 'col1' as valtype, col1 as val from table1 where col1 > 0 union all select id, 'col2', col2 from table1 where col2 > 0 union all select id,…
I have a table "messages" ['id', 'en', 'type', 'company_id'] i have two types ['new_contract', 'new_offer'] i may have two records with the same 'type' = 'type' but one with a company_id and one with a null 'company_id' i want to…
I have more or less the following table: list_id key 1 a 1 b 1 c 2 d 2 e 3 f 3 g ... ... Given a certain key or set of keys, what sql query will return all…
CREATE TABLE table (`id` int, `date` date, `time` time); INSERT INTO table (`id`, `date`, `time`) VALUES (1, '2022-05-22', 14:00:00), (2, '2022-05-23', 07:35:00), (4, '2022-05-23', 14:00:00); Expected Output: date time 2022-05-22 14:00:00 2022-05-22 NULL 2022-05-23 07:35:00 2022-05-23 14:00:00 As you notice,…
I have a very simple table that contains Status_var and description. You can see example here: http://sqlfiddle.com/#!18/3e0d1/5 I need to be able to count how many 'Pass' string occurences are in Status_var column and calculate percentage. Example table below: In…
aid bid 1 2 1 3 2 3 3 4 5 6 7 8 8 10 8 9 I would like to extarct the hierarchy linkage for aid and bid. No need to show each path, any id should show…