create a view postgresql code example
Example 1: postgresql crete view
CREATE VIEW custom_view AS
(SELECT ...)
Example 2: sql view postgresql
SELECT
*
FROM
customer_master;
Example 3: sql view postgresql
CREATE VIEW customer_master AS
SELECT cu.customer_id AS id,
cu.first_name || ' ' || cu.last_name AS name,
a.address,
a.postal_code AS "zip code",
a.phone,
city.city,
country.country,
CASE
WHEN cu.activebool THEN 'active'
ELSE ''
END AS notes,
cu.store_id AS sid,
cu.email
FROM customer cu
INNER JOIN address a USING (address_id)
INNER JOIN city USING (city_id)
INNER JOIN country USING (country_id);
Example 4: create a view postgres
CREATE VIEW influencers AS
SELECT name, email, created_at
FROM users
WHERE follower_count > 1000;