/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 vote232 views1 answer
How to compile a function in oracle
SQL
7 votes151 views1 answer
Mysql load data infile csv
SQL
2 votes331 views1 answer
Set auto increment from 1
SQL
0 vote186 views1 answer
Mysql a from on this page has
SQL
1 vote176 views1 answer
Postgres set column equal to another
SQL
0 vote187 views1 answer
Renommer table sql
SQL
7 votes166 views6 answers
Reset identity column in sql server
SQL
6 votes193 views1 answer
Allsource oracle
SQL
6 votes168 views4 answers
Delete table sqlite
SQL
5 votes212 views1 answer
How to use rank function in sql
SQL

Share