/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

28 votes332 views6 answers
Mysql change user password
SQL
0 vote311 views1 answer
List MySQL Table and Index Size
SQL
2 votes320 views1 answer
Node and mysql like
SQL
0 vote341 views1 answer
Apex for oracle 11g
SQL
0 vote323 views1 answer
Count characters of string mysql
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
9 votes331 views4 answers
SQL Date Format
SQL
0 vote330 views3 answers
Osx stop mysql service
SQL
0 vote331 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote326 views1 answer
Select 1 from orders
SQL

Share