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

5 votes246 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote206 views1 answer
Clone table structure mysql
SQL
0 vote243 views1 answer
Insert into Select * - NAYCode.com
SQL
54 votes354 views6 answers
Sql rename column
SQL
1 vote253 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote225 views1 answer
Select insert new table sql server
SQL
0 vote252 views1 answer
Check if mysql db is used
SQL
0 vote234 views1 answer
Distinct data types in a table sql query
SQL
0 vote237 views1 answer
Hoq to import database source
SQL
0 vote237 views1 answer
PGSQL dynamic table name
SQL