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 vote174 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote189 views1 answer
Query for all indexes in table postgres
SQL
33 votes181 views6 answers
Change column name in mysql
SQL
4 votes182 views1 answer
Phone number sql
SQL
0 vote137 views1 answer
Split a string with expression and get the last value of split sql
SQL
1 vote206 views1 answer
Events mysql
SQL
0 vote182 views1 answer
Mysql update privileges
SQL
0 vote284 views1 answer
Sqlite woth cmake
SQL
1 vote167 views1 answer
PLS-00225 type
SQL
0 vote244 views1 answer
Manage Database in MySQL
SQL