79702970

Date: 2025-07-16 06:05:03
Score: 1.5
Natty:
Report link

I did find a nice workaround for Postgres and other sql products which follow the sql standard and does not allow EXCLUDE or EXCEPT keywords.
We can simply create a view for our table:-
CREATE VIEW viewname AS
SELECT all, columns, you, want, to, show
FROM your_table;
then simply,
SELECT * FROM viewname;

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Aritra Roy