/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 vote115 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote107 views1 answer
How to see logical reads in sql server
SQL
0 vote110 views1 answer
Heidisql check how much space a row
SQL
1 vote152 views1 answer
Sql comment header
SQL
0 vote106 views1 answer
Plpgsql if statement
SQL
0 vote112 views1 answer
Oracle drop type
SQL
61 votes274 views6 answers
Mysql add column
SQL
0 vote101 views3 answers
Remove folders from remote git
SQL
1 vote151 views1 answer
Sql server delete top 1000
SQL
1 vote115 views1 answer
Change table to innodb mysql
SQL

Share