Question: how to create view in pgadmin?
Answer: Use the Name field to add a descriptive name for the view. ...  Use the drop-down listbox next to Owner to select the role that will own the view. If applicable, select the name of the schema in which the view will reside from the drop-down listbox in the Schema field.