There is a table called TableA and anther table called TableB both of them are in same sever i want to create a viwe called TEST in TableA which takes Username, ID columns to the view from suser table in TableB

so how can I do this in PostgreSQL I used several tries and learn I need to create a foreign data wrapper and a db-link I want to know is there another way to do this easily because creating db-link make the process slow