Postgres: Views

(Last Updated On: )

To create a view is rather simple.

 CREATE OR REPLACE VIEW Audit.vw_Your_Table AS
      SELECT *
      FROM Your_table;

Comment on View:

 COMMENT ON VIEW Audit.vw_Your_Table IS 'Display the data';