Postgres create view

Postgresql crete view

CREATE VIEW custom_view AS
	(SELECT ...)

Create a view postgres

CREATE VIEW influencers AS
  SELECT name, email, created_at
  FROM users
  WHERE follower_count > 1000;

Source: learn.coderslang.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 vote131 views1 answer
ALV GRID events
SQL
3 votes125 views2 answers
Mysql create timestamp column
SQL
0 vote143 views3 answers
Insert query in ci
SQL
0 vote150 views1 answer
How much space does sql server take per row
SQL
0 vote136 views1 answer
Oracle insert single quote in string
SQL
2 votes119 views1 answer
Sql alchemy or
SQL
0 vote146 views1 answer
Mysql subtract month from timestamp
SQL
0 vote131 views1 answer
Create mysql pool connection python flask
SQL
0 vote134 views1 answer
Mysql backup query
SQL
0 vote153 views1 answer
Example of sql querry result sepapreted by comma
SQL