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 vote173 views1 answer
Sql counter column
SQL
1 vote197 views1 answer
Mamp mysql path mac
SQL
0 vote165 views1 answer
Phpmyadmin tabellentyp ändern
SQL
16 votes159 views2 answers
Gremove folder from git
SQL
1 vote162 views1 answer
Substr sql last character
SQL
0 vote287 views1 answer
Sql change a colum to unique
SQL
22 votes174 views4 answers
Tsql rename table
SQL
0 vote168 views1 answer
Mysql money value
SQL
0 vote177 views1 answer
Php get closest location by latitude longitude
SQL
2 votes165 views2 answers
Get all tables using like
SQL