Is it possible to create a global alias for a table in psql?

user_3581875 0
Viewed 664

We have a table called Table1, and we want to create an alias for it, e.g. Table2, so that in any query it is understood as Table1. Is it possible in psql?

alias postgresql sql
1 Answers

You can use a view:

create view table2 as
     select * from table1;
user_11440350
Related