I have two tables. table 1 Column A Column B rgz 1 dry 1 vgy 2 chy 3 pom 2 table 2 Column C Column D tuv 10 tuv 11 chx 22 lmn 34 I want the following result shown on data output of postgres PgAdmin ...

We have the definition of the table below CREATE TABLE Log ( LogId serial not null, JobId integer not null, Time timestamp without time zone,...

In PostgreSQL, I have a table with some settings the user can make. In that table there is also a "global" user that takes place if the user doesn't have any settings for them. This query ...

I get hacked by several tables dropping for the postgres database. It is on a cloud ECS environment. During the hack, I realized the attack and created a snapshot but unfortunately I still have ...

I'm dealing with an older PostgreSQL database running on version 9.2.15. I aim to upgrade it to the latest version 16.1 without losing data if possible. Should I perform incremental updates to major ...

In mysql when I enter the following mysql -u root -p Password: enter password successfully I then get into my local server and from here I can view all my databases using SHOW DATABASES. But when I ...

Hello good people of stackoverflow! I need help with writing a query, to identify online time grouped by users, and also to identify which are the periods where there were 0 users online and for how ...

I have a very very old Postgres version 9.2.23 DB that has very little log activity. I want to prevent any logs from being deleted. Currently the log_collector is configured to rotate the logs every ...

Specs: PostgreSQL 9.2.18 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit I'm on MacOS 13.2.1, using DBeaver IDE (version 23.0.4.202305071722) to connect to ...

my_events table stores event_id, event_date, event_type, event_duration. There are many event types for example: Event A, Event B, Event C, Event D The query that I have written will get my results ...

I upgraded my local Postgresql test server to PostgreSQL15 today morning. Opening pgAdmin gave me a warning that some of the features may not work correctly because I have a server with version 9 ...

When I try to open "pg_hba.conf" file, keep getting the following error: pg_ctl: directory "C:/Program Files/PostgreSQL/13/data" does not exist The reload command returned an ...

I am not able to query the contents of the Notification_log table. The table is in a Postgres 9.2 instance that stores my hive metadata. hive=# SELECT table_catalog, table_schema, table_name FROM ...

I'm a complete beginner to Postgresql and Postgis and I can't figure how to do this: I have 3 tables, T1, T2 and T3. T1 and T2 have ID as common column. T2 and T3 can be joined on the geom column. T1 ...

I have a table called device_info that looks like below (only a sample provided) device_ip cpu memory 100.33.1.0 10.0 29.33 110.35.58.2 3.0, 2.0 20.47 220.17.58.3 4.0, 3.0 23.17 30.13.18.8 -1 26.47 70....