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 vote249 views1 answer
What is metadata in sql
SQL
1 vote176 views2 answers
How to drop a unique constraint in sql
SQL
0 vote211 views1 answer
Use mysql in java program
SQL
1 vote237 views1 answer
Drop colum oracle 18c
SQL
1 vote198 views1 answer
Second last highest id in sql
SQL
0 vote193 views1 answer
Mysql group by range
SQL
0 vote209 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote189 views1 answer
Sqlite referential integrity
SQL
4 votes211 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote209 views1 answer
Get rows from 1 table with other table empty mysql
SQL