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

0 vote252 views1 answer
Mod function example
SQL
2 votes270 views1 answer
How to find constraints on a table in oracle
SQL
0 vote283 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote279 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote251 views1 answer
Mysql update sequence with order by
SQL
0 vote236 views1 answer
Create dabase postgresql
SQL
0 vote277 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote284 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote274 views1 answer
Duplix print in Smartforms
SQL
0 vote274 views1 answer
Select * where id = 1,2,3
SQL