You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
26 lines
491 B
Plaintext
26 lines
491 B
Plaintext
-- Create a view
|
|
CREATE OR REPLACE view_name AS
|
|
query;
|
|
|
|
-- Create a recurisve view:
|
|
CREATE RECURSIVE VIEW view_name(columns) AS
|
|
SELECT columns;
|
|
|
|
-- Create a materialized view:
|
|
CREATE MATERIALIZED VIEW view_name
|
|
AS
|
|
query
|
|
WITH [NO] DATA;
|
|
|
|
-- Refresh a materialized view
|
|
REFRESH MATERIALIZED VIEW CONCURRENTLY view_name;
|
|
|
|
-- Drop a view
|
|
DROP VIEW [ IF EXISTS ] view_name;
|
|
|
|
-- Drop a materialized view
|
|
DROP MATERIALIZED VIEW view_name;
|
|
|
|
-- Rename a view
|
|
ALTER VIEW view_name RENAME TO new_name;
|