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 vote282 views2 answers
Begin transaction in sql
SQL
0 vote322 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote281 views1 answer
Mysql drop trigger
SQL
0 vote257 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote303 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote272 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote253 views1 answer
Mysql group rows with same value
SQL
0 vote341 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote253 views1 answer
Mysql autoincrement valor inicial
SQL
1 vote270 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL