Questions tagged [postgres-12]
32 questions
0
votes
1 answer
SQL subqueries PostgreSQL 12
I'm having a table similar to this:
first
last
date
pos
john
doe
18-03-2021
harris
potter
10-06-2021
john
doe
10-05-2021
harris
potter
14-06-2021
jessica
potter
14-06-2021
kermit
foster
The use case is as follow:
The…
Hey StackExchange
- 2,057
- 3
- 19
- 35
-1
votes
1 answer
Postgresql find a string inside the columns of all tables
I want to search for a string that is inside of a column of some table. The system has about 200 tables. I need to search all columns of all tables to achieve what I want.
Is it possible in Postgresql 12?
Diego Alves
- 2,462
- 3
- 32
- 65