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 vote154 views1 answer
Sql bild in function
SQL
2 votes293 views5 answers
Unique in sql server
SQL
-1 vote142 views5 answers
Online sql to linq generator
SQL
0 vote153 views1 answer
Tsql pad left
SQL
5 votes147 views1 answer
Commentaire table oracle
SQL
3 votes142 views2 answers
Mysql create timestamp column
SQL
0 vote166 views1 answer
Sql select sum group by id laravel join
SQL
0 vote142 views1 answer
Dbms_output sql developer
SQL
1 vote148 views1 answer
Show indices in mysql table
SQL
0 vote150 views1 answer
Sql stored procedure update if parameter is not null
SQL