/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 vote172 views1 answer
Sql change primary key to composite key
SQL
6 votes194 views2 answers
Mysql 1 day ago
SQL
1 vote191 views1 answer
UseSqlServer no definition
SQL
-1 vote179 views3 answers
Compute age mysql
SQL
0 vote314 views1 answer
Sqlite display data in separated columns
SQL
0 vote185 views1 answer
Update sqlite
SQL
0 vote174 views1 answer
Guid string to binary better
SQL
0 vote184 views1 answer
How to inner join 4 tables in sql
SQL
0 vote178 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote174 views1 answer
Select row from mysql where date more than 30 days
SQL

Share