DECLARE _retention bigint := (SELECT retention_days FROM retention_period WHERE fulfilment_type = 'daily'); If the SELECT query returns null because "daily" doesn't exist in the retention_period table, how can I return a default value please?
I have the following SQL statement: SELECT DISTINCT e.eventid, e.objectid, e.clock, e.ns, e.name, e.severity FROM events e, functions f, items i, hosts_groups hg WHERE e.source = '0' AND e.object = '0' AND NOT EXISTS (SELECT NULL FROM functions f, items…
I meet some JPA behavior I cannot understand. I'm saving specific dateTime ex. 2023-01-01T12:00:00Z (this is Instant) to Postgresql Timestamp without timezone. I'm reading this value and receive the same date: 2023-01-01T12:00:00Z which is expected. I change server timezone from…
I am trying to export some rows from postgresql table in Datagrip in SQL-Insert-Multirow format. I managed to export 410k rows but when number was above 6 million rows Datagrip throws exception. Is there a way to increase export limit.…
I use go-pg package to work with postgres. I have the following model: type DataItem struct{ tableName struct{} `pg:"some_table"` SomeID string `pg:"some_id,pk"` SomeData string `pg:"some_data"` UpdatedAt time.Time `pg:"updated_at"` } At some point I need to delete all records from the…
I have two existing tables: user_table and post. I need to make the relation between these two tables i.e. add user_id to the post table. I have the following migration ALTER TABLE post ADD CONSTRAINT fk_post_user_id FOREIGN KEY (user_id) REFERENCES…
I have a table. The table has several columns with user ids. There is only one table with users. If there was one column, then everything is clear, we do join user_id = users.id and then use users.name. What if…
I am using Sequelize with Node.js and TypeScript to connect to a PostgreSQL database. I want to export and import a single Sequelize instance throughout my application, so that I have a single connection to the database. I have seen…
I have created a table named 'excel', to read and store .csv in table in pgAdmin-4. Table has been successfully created but when I try to import the data, It shows permission denied. I tried to import the data and…
I have installed PostgreSQL-15.3 and pgAdmin 4 on my system, and set up everything requires, but I am facing this error. This is the error I am facing I have data showing on pgAdmin