I have this table: dbchatbot=# d messages Table "public.messages" Column | Type | Collation | Nullable | Default -----------------+-----------------------------+-----------+----------+--------- uuid | character varying(36) | | not null | content | text | | | Indexes: "messages_pkey" PRIMARY KEY, btree (uuid)…
I'm transitioning to Drizzle ORM from a NestJS-TypeORM background : TypeORM: Both the repository and query builder return similar structured results, making it easy to work with joined data. Drizzle: db.query() returns nicely structured nested data (e.g., users and their…
Given that PostgreSQL gives no guarantees as to the order in which operands are evaluated, could this expression return UNKNOWN if the last condition is evaluated before the middle one? "TradeOffer".status = 'Pending' AND "TradeOffer".expiration_date IS NOT NULL AND CURRENT_TIMESTAMP…
I have a table: CREATE EXTENSION btree_gist; CREATE TABLE excllock ( id BIGSERIAL PRIMARY KEY, myrange INT8RANGE NOT NULL, key UUID NOT NULL, isread BOOLEAN NOT NULL, EXCLUDE USING gist ( myrange WITH &&, key WITH = ) ); I'd…
I have only one database, and only one table named WorkingDirectory. I want to copy folder structure from source (RootFolder1) folder and paste it into destination (RootFolder2) folder in the same table using C#. Below parameter passed from the UI…
I am trying to sort a column title from the table door with the following PostgreSQL query: SELECT title FROM door ORDER BY CASE WHEN title ~ '^d+' THEN CAST(regexp_replace(title, '[^0-9]', '', 'g') AS INTEGER) ELSE NULL END ASC, CASE…
I have a gigantic indexed (104 million row) table of docs, pages and words: CREATE TABLE my_table ( doc_id integer, page_id integer, word_id integer ); CREATE INDEX my_table_word ON my_table (word_id); CREATE INDEX my_table_doc ON my_table (doc_id); CREATE INDEX my_table_page…
I have this table: | arrs | |:----| | {10000,10000,10000,10000} | | {100,200,300} | | {400,500,600} | | {100,200,600} | How get this result? | uniques | |:-------| | 10000 | | 100 | | 200 | | 300 |…
I am trying to group rows on a postgres query. I have one row of data that has a field with a line number in it. The next 3 rows are null. I want to set them to the same…
I want to write a script for mass importing hundreds of csv files into PostgreSQL with differing columns/formatting How do you bulk import data that has differing columns/formats into another table on postgresql using a csv file? For example this…