/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

2 votes112 views2 answers
Sql query to copy data from one column to another
SQL
5 votes99 views1 answer
Invalid column name sql
SQL
39 votes169 views4 answers
Select duplicates in sql
SQL
3 votes109 views1 answer
Create a table with an id in mysql
SQL
45 votes179 views5 answers
Grant all privileges mysql
SQL
0 vote119 views1 answer
Set Mamp mysql globally
SQL
6 votes101 views1 answer
Postgres get size of database
SQL
0 vote172 views1 answer
Mysql update all record removing 2 hours from column
SQL
5 votes106 views2 answers
Create function postgresql
SQL
0 vote102 views1 answer
Mysql add to number
SQL

Share