How would one have dynamic "secondary" keys? For example, how we have it in Jira. We have a project name, for example "Test" with the shortcut "TEST". All associated tickets in this project are given a ID "TEST-1234", "TEST-1235", and…
I have installed PostgreSQL via cPanel for my site. It looks like I can access the database using the pgAdmin provided by cPanel. However, I would like to connect to the database (running on my site) remotely using pgAdmin running…
I have a very large table (over a TB space) in a postgres db and it has a text column which is also large causing TOASTING in the db. When I try do drop the column it times out after…
I have a table named "liverpool_players" and I'm trying to create a new one with an additional column "years_at_club", which I mean for to be autogenerated as at date 31 Dec 2024. I run the following sql statements in PostgreSQL:…
I'm trying to insert data with parameters to PostgreSQL 16 in C#. I have the following code: using (var myConnection = new NpgsqlConnection(myConnectionString)) { myConnection.Open(); var insertAllData = $@" DO $$ DECLARE new_production_item_id INTEGER; BEGIN INSERT INTO public.production_items (my_data_type_id, created_by,…
I am in need to use the Word Boundary(y) as a condition to match the exact word which is been searched as a Query Param. I am writing this regex and executing in PostgreSQL but it is returning FALSE. text_search_value…
I want to splits a string on '_' and replace 3rd group with 'oooo'. Is there any way to do it simply and without assuming there's exactly 5 groups? CONCAT( SPLIT_PART(test, '_', 1) ,SPLIT_PART(test, '_', 2) ,'OOOO' ,SPLIT_PART(test, '_', 4)…
In my Postgres table I’ve got two columns, one of them sometimes have strings, the other one is empty, but some strings from first column sometimes has substrings, I want to move data from first column to another if it…
Here is an example of the query I'm trying to execute and the POJO I'm trying to populate. public Optional<TeacherWithStudents> getTeachersWithStudentsForStudentId(long studentId) { return ctx().select( TEACHER.ID, TEACHER.NAME, DSL.field("student.ids", STUDENT_TEACHER_MAPPING.STUDENT_ID.getDataType().getArrayType())) .from(TEACHER) .leftJoin(DSL.lateral( DSL.select(DSL.arrayAgg(STUDENT_TEACHER_MAPPING.STUDENT_ID).as("ids")) .from(STUDENT_TEACHER_MAPPING) .where(STUDENT_TEACHER_MAPPING.TEACHER_ID.eq(TEACHER.ID))).as("student")) .on(DSL.condition(true)) .limit(1) .fetchOptionalInto(TeacherWithStudents.class); } // TeacherWithStudents…
As stated in my question, I am now configuring my djagno project to connect with postgres. The issue i am facing is that, when making migrations, it shows me the following error: python manage.py makemigrations Traceback (most recent call last):…