/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 vote162 views1 answer
Mariadb hours between two dates
SQL
34 votes168 views6 answers
Alter table add foreign key mysql
SQL
0 vote161 views1 answer
Add new column in sql with foreign key
SQL
0 vote133 views1 answer
Mariadb errno 121
SQL
0 vote140 views1 answer
Java nosql sort
SQL
3 votes168 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote142 views1 answer
Mysql check if lowercase
SQL
0 vote141 views1 answer
Mysql get last 2 month data
SQL
0 vote173 views1 answer
Call function sql oracle with output put line
SQL
0 vote149 views1 answer
Define a variable in mysql from select
SQL

Share