Can't create tables in public schema as non-superuser postgres - super user. What I've done: ALTER SCHEMA public owner to postgres; CREATE USER admin WITH PASSWORD 'my-password'; GRANT USAGE, CREATE ON SCHEMA public TO postgres; GRANT USAGE, CREATE ON SCHEMA…
I'm using Postgres with Golang via pgx I've a trigger function something like the following: CREATE OR REPLACE FUNCTION foo() RETURNS TRIGGER AS $$ BEGIN IF (bar = 'baz') THEN -- something ELSE RAISE EXCEPTION 'oops error'; END IF; RETURN…
A Kafka topic is not created when I use start the Debezium connector for PostgreSQL. Here's what I have in my properties file: name=testdb connector.class=io.debezium.connector.postgresql.PostgresConnector topic.prefix=test database.hostname=localhost database.port=5432 database.user=postgres database.password=root database.dbname=testdb database.server.name=testdb table.include.list=ipaddrs plugin.name=pgoutput According to this, the topic should…
I am new to SQL and I've been struggling with this example for quite a while now. I have this table: So, what is asked from me is to produce a count of the number of recommendations each member has…
I am trying to write a query that returns all the strings that are not present in a table when given a list of strings. When I execute something like: select * from public.person where person_name in ('John', 'Doe', 'Mike')…
Is there a way to backup all of the databases on a hyperscaler managed postgres server as of a certain time in order to maintain data consistency between the databases with either pg_dumpall, pg_dump or something else? Background: With the…
I'm using a client library that only accepts SQL strings that are compile-time constant, in order to prevent SQL injection attacks. And I wanted to execute some GRANT statements for a set of tables and a user. I tried GRANT…
I have a JSON a = { cake: ["a","b","c","d"] } I need to query any value in a given values are present in the array Like if the input is ["a","x"] output should be true if input is ["c","d"] then…
I am trying to build a storage manager where users can store their lab samples/data. Unfortunately, this means that the tables will end up being quite dynamic, as each sample might have different data associated with it. I will still…
I'm trying to filter vacations by date range, but I don't know how to do it. Please help. Database: postgresql Backend: nestjs + prisma orm (4.0.0) Frontend: React The data about vacations is stored in the database in this form:…