New answers tagged postgresql-9.6
3
votes
Better way to return list of FK "parent" tables?
Just the list of parent tables and column names.
"Children"
I fixed the terminology. What you display are the tables referencing the input table. So "children", not "parents&...
- 170k
0
votes
Postgres Specific table access
Have you considered moving the table to a new schema? Then you could grant user access to the schema and drop and create tables with consistent permissions.
- 125
0
votes
Performance difference using CTE and subquery
Outdated Postgres version
PostgreSQL 9.6 has reached EOL in 2021 at the point release of 9.6.24 (!) - not 9.6.7.
Upgrade to a current version at the earliest opportunity. If that's not an option, at ...
- 170k
2
votes
Performance difference using CTE and subquery
We would need to see the table definitions (particularly the keys and indexes) and query plans to be able to tell you with any confidence, so you should edit those details into your question. Also, ...
- 31.7k
Top 50 recent answers are included