Postgresql crete view

CREATE VIEW custom_view AS
	(SELECT ...)

Sql view postgresql

        
            
        
     CREATE OR REPLACE view_name 
AS 
query

Source: postgresqltutorial.com

Postgres create view

CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, ...] ) ]
    [ WITH ( view_option_name [= view_option_value] [, ... ] ) ]
    AS query

-1

Source: postgresql.org

Similar codes

1 vote145 views1 answer
Alter user mysql native password
SQL
0 vote207 views1 answer
Helptext in sql
SQL
0 vote230 views1 answer
Mysql show schema
SQL
0 vote197 views2 answers
Sql query for getting details by id
SQL
1 vote238 views1 answer
Postgresql where datetrunc month and year equal
SQL
-1 vote194 views1 answer
Su: Authentication failure mysql
SQL
3 votes223 views4 answers
Psql list tables in schema
SQL
1 vote194 views1 answer
Sql pick random row
SQL
1 vote135 views1 answer
Insert into sql
SQL
0 vote241 views1 answer
Add week ending date sql server
SQL