Answers for "postgresql views"

SQL
1

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
   FROM customer cu
     INNER JOIN address a USING (address_id)
     INNER JOIN city USING (city_id)
     INNER JOIN country USING (country_id);
Posted by: Guest on November-09-2020
2

postgresql crete view

CREATE VIEW custom_view AS
	(SELECT ...)
Posted by: Guest on February-01-2021
0

sql view postgresql

CREATE OR REPLACE view_name 
AS 
query
Posted by: Guest on November-09-2020
0

postgres call view

SELECT * FROM viewname;
Posted by: Guest on November-06-2020
0

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);
Posted by: Guest on November-09-2020
0

sql view postgresql

SELECT
	*
FROM
	customer_master;
Posted by: Guest on November-09-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language