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 vote265 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote259 views2 answers
Mysql join two tables
SQL
1 vote276 views1 answer
Round function in sql oracle
SQL
9 votes253 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote293 views1 answer
Prisma transaction
SQL
0 vote274 views1 answer
Get date from timestamp in mysql
SQL
1 vote263 views1 answer
Float precision in psql
SQL
18 votes268 views3 answers
Find column name in database
SQL
0 vote278 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote320 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL