|
Its really nice to see/read the pretty printing of VIEW definations!! in 7.3 it was a nightmare to see definations of long views. Kudos to the TEAM. Regds Mallah tradein_clients=# \d XYZ View XYZ Column | Type | Modifiers -------------+-------------------+----------- id | integer | branch | character varying | source | character varying | co_name | character varying | address | text | city | character varying | pin_code | character varying | phone | character varying | fax | character varying | contact | character varying | email | character varying | size | character varying | status | boolean | category_id | integer | keywords | text | edition | smallint | sno | integer | View definition: SELECT eyp_listing.list_id AS id, eyp_listing.branch, 'EYP'::character varying AS source, eyp_listing.co_name, ((( CASE WHEN eyp_listing.address1 IS NOT NULL THEN eyp_listing.address1 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text || ' '::character varying::text) || CASE WHEN eyp_listing.address2 IS NOT NULL THEN eyp_listing.address2 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text) || ' '::character varying::text) || CASE WHEN eyp_listing.address3 IS NOT NULL THEN eyp_listing.address3 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text AS address, eyp_listing.city, eyp_listing.pin_code, eyp_listing.phone, eyp_listing.fax, eyp_listing.contact, eyp_listing.email, eyp_listing.size, true AS status, eyp_listing.category_id, eyp_listing.keywords, eyp_listing.edition, eyp_listing.sno FROM ONLY public.eyp_listing WHERE (eyp_listing.category_id = 1142 OR eyp_listing.category_id = 1143 OR eyp_listing.category_id = 1145 OR eyp_listing.category_id = 1259 OR eyp_listing.category_id = 1161) AND eyp_listing.amount > 0 AND eyp_listing.status::text = 'a'::character varying::text AND eyp_listing.email IS NOT NULL AND eyp_listing.email::text !~~* '%.trade-india.com'::text UNION ALL SELECT iid_listing.list_id AS id, iid_listing.branch, 'IID'::character varying AS source, iid_listing.co_name, ((( CASE WHEN iid_listing.address1 IS NOT NULL THEN iid_listing.address1 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text || ' '::character varying::text) || CASE WHEN iid_listing.address2 IS NOT NULL THEN iid_listing.address2 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text) || ' '::character varying::text) || CASE WHEN iid_listing.address3 IS NOT NULL THEN iid_listing.address3 WHEN '' IS NOT NULL THEN ''::character varying ELSE NULL::character varying END::text AS address, iid_listing.city, iid_listing.pin_code, iid_listing.phone, iid_listing.fax, iid_listing.contact, iid_listing.email, iid_listing.size, true AS status, iid_listing.category_id, iid_listing.keywords, iid_listing.edition, iid_listing.sno FROM ONLY public.iid_listing WHERE (iid_listing.category_id = 1142 OR iid_listing.category_id = 1143 OR iid_listing.category_id = 1145 OR iid_listing.category_id = 1259 OR iid_listing.category_id = 1161) AND iid_listing.amount > 0 AND iid_listing.status::text = 'a'::character varying::text AND iid_listing.email::text !~~* '%.trade-india.com'::text AND iid_listing.email IS NOT NULL UNION ALL SELECT DISTINCT ON (company_id) company_id AS id, trade_india_branch AS branch, 'BRANDING'::character varying AS source, comp_name AS co_name, office_addr AS address, city, pincode AS pin_code, phone_no AS phone, fax_no AS fax, key_exec AS contact, email, 'BRANDING' AS size, false AS status, category_id, serv_prov AS keywords, branding_master.edition, 0 AS sno FROM ONLY public.branding_master JOIN ONLY public.branding_sp_category USING (company_id) WHERE (category_id = 1142 OR category_id = 1143 OR category_id = 1145 OR category_id = 1259 OR category_id = 1161) AND old_company_id = 0 AND status::text = 'a'::character varying::text AND email::text !~~* '%.trade-india.com'::text AND email IS NOT NULL ORDER BY company_id; -- Rajesh Kumar Mallah, Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace. |
