Yes, query the geography_columns view (type column) for the said schema, table, column. You can also take a look and see how the view is built.
It is built against the postgresql catalog tables so will always reflect the data type of the geography column. Leo http://www.postgis.us -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Puthick Hok Sent: Thursday, March 03, 2011 11:24 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] How to info like \d command in Perl Hi, I am trying to find a way to retrieve the geography type of a Postgis column in Perl. Using these statements: my $datatype = $sth->{'TYPE'}->[$i]; my @type_info = $dbh->type_info([$datatype]); my $dtype_name = $type_info[0]->{'TYPE_NAME'}; The content of $dtype_name is 'unknown' which is not surprising. In psql client, executing \d command gives me something like: \d contactloc Table "public.contactloc" Column | Type | Modifiers -----------------+-----------------------+----------- contactid | integer | not null contactlocation | geography(Point,4326) | not null Indexes: "contactloc_pkey" PRIMARY KEY, btree (contactid) "contactlocation_sp_index" gist (contactlocation) Is there any way to check whether a geography column a point or a polygon? Regards, Puthick _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users