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

-1 vote111 views3 answers
Psql get last rows
SQL
24 votes106 views4 answers
Postgres delete database
SQL
8 votes127 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote98 views1 answer
Mysql workbench indent formatting
SQL
6 votes104 views2 answers
Mysql get yesterday
SQL
-1 vote101 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
14 votes147 views1 answer
How to export db from mysql
SQL
0 vote130 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote101 views1 answer
Mysql_error replacement
SQL
0 vote119 views1 answer
Permission denied postgres \copy csv command line
SQL