On Tue, 2012-06-12 at 09:40 -0500, Little, Douglas wrote: > 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?
According to the code, it should show the columns datatypes. I have no idea why it doesn't and I don't have a Greenplum database to check that. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support