What is the recommended way to create a graph from a table (or from an SQL query, in general)? Say, we have a table A with fields id and parent_id, where the latter refers back to the former of some…
I have a table Assets table Asset Id | Asset Name | Asset Type | Product Id Transfers Table Transfer Id | From Asset ID | To Asset Id | Product Id I'm trying to join these table to get…
I am trying to create simple trigger to ensure the "from" or "to" (database usernames) is equal to current_user, then can delete the record. But its always raises an exception. Table Schema: CREATE TABLE policy_test ( id serial not null,…
I have two tables and the data in table 1 is in rows. Key column in table 1 has the columns that are as rows now and want to trasnform to column Below is how i have the table now.…
sudo make PG_CONFIG=/Users/pawankukreja/age_installation/pg/postgres/postgresql-12.0/bin/pg_config install; make: /Users/pawankukreja/age_installation/pg/postgres/postgresql-12.0/bin/pg_config: Command not found make: *** No rule to make target `install'. Stop. I found this error while installing the PostgreSQL, I want to install apache age and PostgreSQL but encountered this error while installing.
I am trying to get data from a view which returns users name and tags (comma separated numbers). Now I want to get a user if it has a certain tag. My view returns this: id | name | tags…
I have following example: create table products (name text, id integer, type smallint, category integer); insert into products values ('apple', 23, 1, 1200), ('apple', 23, 1, 999), ('apple', 31, 2, 1200), ('apple', 23, 3, 1200), ('orange', 10, 1, 200), ('orange',…
I want to find the newest message entry for each chat_id. For example, for this table I need to get list of rows: with id=1c6bad12 for chat_id=ee5152ff and with id=e4485bdf for chat_id=29cc7217. (2th and 6th). id chat_id created_at text 1442a8e8…
Let's assume there is a table: day amount 1 10 2 20 3 30 I want to know when turnover reached 30, in case above it's happened on 2 day. How to query this in SQL? I guess I have…
I am trying to connect to the replication endpoint in a data replication setup. I am using Apache Age. I am not able to establish a connection to the replication endpoint even after making the necessary settings and configuration and…