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 vote170 views1 answer
Mysql show create db
SQL
0 vote158 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
1 vote157 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote170 views1 answer
Codigo crear tablas sql server
SQL
32 votes158 views6 answers
How to change column name in sql
SQL
16 votes157 views2 answers
Oracle ddl
SQL
18 votes145 views4 answers
Mysql current date between two dates
SQL
1 vote146 views1 answer
Mysql query where in select
SQL
1 vote148 views2 answers
Oracle replace
SQL
0 vote150 views1 answer
Column ' ' in field list is ambiguous
SQL