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

4 votes205 views1 answer
Oracle delete last row
SQL
2 votes188 views2 answers
Sqlite_busy: database is locked
SQL
0 vote238 views1 answer
Table structure in sql
SQL
0 vote196 views1 answer
Use between operator in mysql
SQL
3 votes207 views1 answer
How to check schema privileges in oracle
SQL
0 vote220 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
5 votes209 views3 answers
Oracle list columns in schema
SQL
22 votes212 views4 answers
Mysql date format
SQL
0 vote202 views1 answer
How to get initials in sql
SQL
0 vote209 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL