Related

Create Database

psql

Create a new PostgreSQL database

Create User

psql

Create a new PostgreSQL user

Create Table

psql

Create a new PostgreSQL table

psql/create-view

Create View

Create a new PostgreSQL view

view
create

Command

CREATE VIEW viewname AS SELECT column1, column2, ... FROM tablename;

Explanation

Creates a new view in the current database.

Examples

Create view for active users

CREATE VIEW active_users AS SELECT * FROM users WHERE status = 'active';

More

Create Index

psql

Create a new PostgreSQL index

Drop View

psql

Delete a PostgreSQL view

Create Function

psql

Create a new PostgreSQL function