Is it possibile to create aliases for postgresql queries?

Question

I would like to create something like a query that gets called everytime I write an alias. So something like :

myalias = select codes from codetables where validity=current_date ;

then use it like :

select * from mainregistry where code in (myalias) ;

the "myalias" should be available everywhere everytime, so there should be a way of having it "default" in all my dbs.

Jonathan Jacobson · Accepted Answer · 2022-02-03 09:54:40Z

2

It's called a view:

CREATE VIEW myalias AS
SELECT codes
FROM codetables
WHERE validity=current_date;

and then:

SELECT * FROM mainregistry
WHERE code IN (SELECT codes FROM myalias);

answered Feb 3, 2022 at 9:54

Jonathan Jacobson

1,52811 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1