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

3 votes140 views1 answer
Make a field auto_increment mysql
SQL
7 votes144 views2 answers
Phpmyadmin change password
SQL
0 vote87 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
3 votes160 views5 answers
Foreign keys
SQL
1 vote152 views2 answers
This month mysql where
SQL
1 vote138 views1 answer
Mysql get max value and id
SQL
1 vote137 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
20 votes139 views3 answers
Update values in select statement sql
SQL
3 votes151 views1 answer
Oracle revoke
SQL
0 vote148 views1 answer
Limit in access query
SQL