/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 vote159 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote106 views1 answer
Date on SQL
SQL
16 votes101 views3 answers
Delete row psql
SQL
3 votes102 views1 answer
Sql replace character in string in all records
SQL
1 vote102 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
9 votes249 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote113 views1 answer
Mysql url data type
SQL
0 vote111 views1 answer
Add SuperUser MySQL
SQL
0 vote109 views1 answer
Sql period overlap
SQL
7 votes100 views1 answer
Oracle set sequence value to max(id)
SQL

Share