Use this tag to indicate that your question is about PostgreSQL version 15. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-15]
112 questions
-1
votes
1 answer
How can I query a timestamptz column with the timezone of the end user vs. the time zone that it is stored in
I have a table like the image below and if you notice the first row has a timestamptz value of "2023-08-13 11:31:33.013 +0000". My issue is, I need the records to show up for the user if they query for the date range…
Rami
- 490
- 7
- 22
-1
votes
1 answer
Is this function susceptible to SQL injection where the parameter is used in a select statement of an IF/ELSE statement?
Is this function susceptible to SQL injection? Specifically, the use of where signature = _sig in the select statement in the if not exists arm. Can someone pass a malicious value as a parameter to the function?
CREATE OR REPLACE FUNCTION…
sudoExclaimationExclaimation
- 7,992
- 10
- 47
- 105
-1
votes
1 answer
Postgresql logical replication between two machine dont't work
I have two machines with postgresql v15 and a config like this :
https://www.youtube.com/watch?v=p1Y2XCskOhY&ab_channel=EDB
I have set wal_level to logical but de replication not work, i create a pub in Machine 1 and de sub in the 2 machine with…
Hamza Assemlal
- 11
- 2
-1
votes
2 answers
Cannot create a conditional publication based on a user-defined type on PostgreSQL 15
I am trying to publicate the cnt_title table using PostgreSQL Logical Replication. Note that I only want to share the product titles.
create publication cnt_publication_for_stk for table
cnt_title where (doc_type = 'PRODUCT');
What I have found is…
coterobarros
- 941
- 1
- 16
- 25
-2
votes
0 answers
Why doest postgresql return syntax error near '(' for the Left-function?
After following a 2-day SQL training, I wanted to practice for myself in the same database.
I used dbgate and postgreSQL. I wanted a query which returns an overview of the initials that movies start with. Or an overview of the initials that first…
DutchArjo
- 319
- 3
- 8
- 29
-4
votes
1 answer
Junction table vs. many columns vs. arrays in PostgreSQL: Memory and performance
I'm building a Postgres database for a product search (up to 3 million products) with large groups of similar data for each product, e.g. the prices for different countries, and country-specific average ratings, with up to 170 countries.
The natural…
jake n
- 342
- 3
- 15