I try to develop a simple input form to save a deposit for a fishing vessel. The vessel and the net are tables in the database. There is no error when the form is submitted but there is nothing happening…
(obs: the ids are not pk they are unique keys, the pks are a government "id" called cpf); I want to create a function that reads the id in table1 [person] of a person and then insert this [person].id in…
I have a set of normalized tables with one-to-many and many-to-many relationships. For most queries I am really interested in a highly denormalized view which shows: Entity-per-row for one specific table Aggregated information about related entities from other tables Here…
I have JSON stored in a table. The JSON is nested and has the following structure [ { "name": "abc", "ques": [ { "qId": 100 }, { "qId": 200 } ] },{ "name": "xyz", "ques": [ { "qId": 100 },…
I try to create a view which contains calculated data from others table. However, I have this error message: [42701] ERROR: column "id" specified more than once. My SQL script: CREATE VIEW dashboard_view AS SELECT c.libelle_commune AS "commune", count(bv.id) AS…
I have a function: my_function(arg1 integer, arg2 text, arg3, text); I have a view my_view that returns as a row: (arg1, arg2, arg3); I can call my_function() with the row from the view as I would do explicitely: select my_function(arg1…
I need to insert multiple values into a table after checking if it doesn't exist using psycopg2. The query am using: WITH data(name,proj_id) as ( VALUES ('hello',123),('hey',123) ) INSERT INTO keywords(name,proj_id) SELECT d.name,d.proj_id FROM data d WHERE NOT EXISTS (SELECT…
I have just started using PostgreSQL as Back End database. As the title suggested, users will input data into the DB tables through MS ACCESS connected using psql ODBC driver. But I observed a very strange behavior from a linked…
Hei, i have a question about the best practice here. I have a Golang Project which uses as Postgres Database and specific Migrations. The Database has many tables and some depend on each other (Table A has FK to Table…
I wonder if it is possible to achieve uniqueness in an array of objects, only using one field of the object as the determinant if the object is unique or not with jsonb. An example of what I mean: I…