I'm working on a courses Application where the user can sort his content however he like for example say there is Courses Table - contains course data(title, thumnail...) sub-courses and videos Videos Table - contains video data(video url, title...) so…
My table looks like below x y z a ab 2 a ab 4 a ac 4 b ab 6 b ab 4 b ad 8 c ac 10 c ac 10 What I am looking for is this: x…
I'm wondering how I would parameterise the following postgres: UPDATE your_table as t SET val = x.val_to FROM ( VALUES (1, 20), (3, 44) ) as x (val_from, val_to) WHERE t.val = x.val_from AND your_table.other_id = %(other_id_value) ; where (1,…
I have a schema like this one: create table users ( id bigint primary key generated always as identity, name text not null ); create table feature ( id bigint primary key generated always as identity, value text not null…
I came to a standtstill with a relatively trivial issue. Such a simple query: select distinct field_name,length(field_name) from table_a where field_name similar to `2[0-9][0-9]%`; returns the following rows: field_name|length| ----------+------+ 200 | 3| 203 | 3| 210 | 3| But…
Im trying to get all unique values out of two rows in a databank as a list. Using postgresql and python. I use this sql query: SELECT DISTINCT from,to FROM database; I get this output from | to ------+----- a…
I'm working on a module where I'm evaluating method to add thumbprint (x5t#256) value to all public keys present in the DB. Conversion using javascript libraries, java libraries is doable. however trying to convert the same using pgcrypto doesn't seem…
I need you infinite knowledge. I have some kind of data in a column (text) state 0 0,0 13 13,27,0 0,0,0 Is a text column, but it can have a number, or many numbers separate by commas (not defined how…
I am writing a regular expression for capturing the connection string of PostgreSQL. The format of the connection string as follows: (postgresql|postgres)://[userspec@][hostspec][/dbname][?paramspec] where userspec is: user[:password] and hostspec is: [host][:port][,...] and paramspec is: name=value[&...] Here, the userspec, port, dbname and…
There's a table with compound index (col1, col2, col3). There's a lot of data in this table. Want to build query for example WHERE col1 = 2 AND col2 = 12 AND col3 IN (1, 2, 3, ..., 40) Is…