view table in postgresql code example

Example 1: show table postgres command

PostgreSQL show tables command
	
\dt

Example 2: show all tables postgres

\dt
# show list of tables in postgres

Example 3: show details of table postgres

postgres=# \d tablename;

Example 4: sql view postgresql

CREATE OR REPLACE view_name 
AS 
query

Example 5: 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);