In gpadmin running on win7/32bit against greenplum 4.1.2.4 external tables columns are showing without a data type CREATE EXTERNAL TABLE etl_stage_tbls.ext_dim_sitevisit ( md5hash , visitid , visit1ofacctdayind , visit1ofacctind , visit1oftdayind , intentpurchaseind , intentsearchind , intentsvcactind , intentsvcitinind , ip , ...
This is the query being executed by pgadmin The results show the datatype. Is there possibly a display problem? Attaching the query output. Thanks Doug SELECT att.*, def.*, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS defval , CASE WHEN att.attndims > 0 THEN 1 ELSE 0 END AS isarray, format_type(ty.oid,NULL) AS typname , format_type(ty.oid,att.atttypmod) AS displaytypname , tn.nspname as typnspname , et.typname as elemtypname , ty.typstorage AS defaultstorage , cl.relname, na.nspname, att.attstattarget , description, cs.relname AS sername, ns.nspname AS serschema, (SELECT count(1) FROM pg_type t2 WHERE t2.typname=ty.typname) > 1 AS isdup, indkey, EXISTS(SELECT 1 FROM pg_constraint WHERE conrelid=att.attrelid AND contype='f' AND att.attnum=ANY(conkey)) As isfk FROM pg_attribute att JOIN pg_type ty ON ty.oid=atttypid JOIN pg_namespace tn ON tn.oid=ty.typnamespace JOIN pg_class cl ON cl.oid=att.attrelid JOIN pg_namespace na ON na.oid=cl.relnamespace LEFT OUTER JOIN pg_type et ON et.oid=ty.typelem LEFT OUTER JOIN pg_attrdef def ON adrelid=att.attrelid AND adnum=att.attnum LEFT OUTER JOIN pg_description des ON des.objoid=att.attrelid AND des.objsubid=att.attnum LEFT OUTER JOIN (pg_depend JOIN pg_class cs ON objid=cs.oid AND cs.relkind='S') ON refobjid=att.attrelid AND refobjsubid=att.attnum LEFT OUTER JOIN pg_namespace ns ON ns.oid=cs.relnamespace LEFT OUTER JOIN pg_index pi ON pi.indrelid=att.attrelid AND indisprimary WHERE att.attrelid = 18073137::oid AND att.attnum > 0 AND att.attisdropped IS FALSE ORDER BY att.attnum Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide
external_table_data.csv
Description: external_table_data.csv
-- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
