/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

12 votes342 views5 answers
Sql merge
SQL
1 vote373 views1 answer
Mysql last year
SQL
-1 vote363 views2 answers
Sql truncate number
SQL
10 votes309 views1 answer
Oracle view dependencies
SQL
0 vote344 views1 answer
Match end of string regex sql
SQL
0 vote357 views2 answers
Mysql create table if not exists
SQL
2 votes331 views1 answer
Match in sql server
SQL
1 vote348 views2 answers
Copy database mysql
SQL
2 votes353 views1 answer
Mysql last 7 days including today
SQL
0 vote359 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL

Share