/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

1 vote174 views1 answer
Sql server update column based on another table
SQL
-2 votes176 views1 answer
Mysql see users and passwords
SQL
0 vote165 views1 answer
Restore backupfile discourse
SQL
22 votes184 views3 answers
Year format in date mysql
SQL
0 vote167 views1 answer
Sql count total by foreign key
SQL
0 vote173 views1 answer
How to reset table in sql server
SQL
1 vote183 views1 answer
Sql dcl
SQL
0 vote153 views1 answer
Sql examples from your work
SQL
-1 vote136 views1 answer
Oracle db list usernames
SQL
0 vote193 views1 answer
Drop a view in sqlite
SQL

Share