I built this SQL: SELECT indexname FROM pg_indexes WHERE schemaname = 'foo' AND tablename = 'foo' It returns me all indexes of a table. However, I would like the index names and the type of the indexes to be displayed,…
I have the following table which stores historical prices for stocks stock_id | open | close | high | low | timestamp ----------+--------+--------+--------+--------+--------------------- 2 | 338 | 330 | 338 | 330 | 2022-10-21 05:30:00 2 | 341 | 338…
I have a PostgreSQL 12.x database. There is a column data in a table typename that contains jsonb values. The actual JSON data is not fixed to a particular structure; these are some examples: {"emt": {"key": " ", "source": "INPUT"},…
I have a JSON_TEXT column in my PostgreSQL DB such as this {'a':'one', 'b':'two', 'c':'three'} I would like to create a function that would loop through all of the DISTINCT JSON_object_keys and create a column for each of the keys,…
I have the following text from a column called 'subject': Standard WiFi Install - (Broadband) by HS&S - Job No:VR041135037 on 2022-01-14 I need to extract the ID (VR041135037) and the date (2022-01-14) from the subject column. What query can…
I have two queries that count the total of employees according to multiple conditions; the only thing that changes is the last two AND clauses; I don't know how I can return the results in the same query. First Query…
I'm trying to detect users first sessions. ID event_server_date Event Row_number 1 2022-10-26 09:43 abc 1 1 2022-10-26 09:45 cde 2 1 2022-10-26 09:47 ykz 3 1 2022-10-26 09:48 fun 4 1 2022-10-26 09:50 start_event 5 1 2022-10-26 09:55 x…
I have a CSV file my_table.csv that looks like the following: "dt_start","my_int_value","my_double_value","dt_version" "2022-01-02 00:00:00",2,2.2,"2022-01-02 00:00:00" "2022-01-03 00:00:00",3,3.3,"2022-01-03 00:00:00" Now I simply want to import this file into a table my_table of my PostgreSQL database from Python using the instructions from…
I am new to PSQL so I am sorry if it's a silly mistake, but I am having the following problem. I am trying to make a list that show the user and the places that they haven't gone to…
I have some records in database that are containing Serbian latin letters (ć, č, đ, ž, š). I've done search functionality in backend (nestjs) to search all columns in table that contain typed characters on frontend (react). How could I…