/SQL/Create a view postgres

Create a view postgres

Postgresql crete view

CREATE VIEW custom_view AS
	(SELECT ...)

2

Create a view postgres

CREATE VIEW influencers AS
  SELECT name, email, created_at
  FROM users
  WHERE follower_count > 1000;

1

Source: learn.coderslang.com

Sql view postgresql

        
            
        
     CREATE OR REPLACE view_name 
AS 
query

0

Source: postgresqltutorial.com

Similar codes

0 vote259 views1 answer
Compare subqueries oracle
SQL
4 votes233 views1 answer
Sql query to make a existing column auto increment
SQL
5 votes255 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote242 views1 answer
Oracle last connexion
SQL
0 vote231 views1 answer
Mysql return column names when table is empty
SQL
0 vote239 views1 answer
Odd record sql query
SQL
0 vote245 views1 answer
Implicit inner join table alias
SQL
0 vote223 views1 answer
Postgresql subquery
SQL
7 votes249 views3 answers
Sql server reset auto increment
SQL
9 votes263 views3 answers
Where clause sql
SQL

Share