/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 vote171 views1 answer
Day of the week sqlite
SQL
3 votes151 views6 answers
DB::table('users')->get();
SQL
1 vote122 views1 answer
Pentaho + pasar de excel a sql
SQL
79 votes326 views6 answers
Grepper code
SQL
6 votes150 views4 answers
Mysql group by month
SQL
0 vote148 views1 answer
Mariadb alter table add column if not exists example
SQL
1 vote128 views1 answer
Sql server reseed single table
SQL
1 vote220 views3 answers
Showing all columns in an sqlite table
SQL
0 vote181 views1 answer
SQL check if record exist
SQL
0 vote129 views1 answer
Check if a word appears at the end sql query
SQL

Share