Re: [postgis-users] One-to-many join

/30/2012 09:00 PM, John Morgan wrote: > >> Hello, >> I am attempting to get a one (polys) to many (table) to load postgis data >> within a mapserver wms. I have the following defined in the .map file. >> >> DATA "the_geom FROM (SELECT polys.gid AS gid, polys

Re: [postgis-users] One-to-many join

tions. Thanks for your feedback guys. Derek On Mon, Jan 30, 2012 at 10:54 PM, Andy Colson wrote: > On 01/30/2012 09:00 PM, John Morgan wrote: > >> Hello, >> I am attempting to get a one (polys) to many (table) to load postgis data >> within a mapserver wms. I have

[postgis-users] One-to-many join

Hello, I am attempting to get a one (polys) to many (table) to load postgis data within a mapserver wms. I have the following defined in the .map file. DATA "the_geom FROM (SELECT polys.gid AS gid, polys.the_g eom AS the_geom, table.pt_id AS pt_id, table.agent AS agent FROM polys RIGHT OUTER JOIN

Re: [postgis-users] tool to load dbf into postgresql table

Thanks for the feedback guys. The -n option on shp2pgsql worked well. Derek On Sun, Jan 29, 2012 at 9:17 PM, John Morgan wrote: > Hello, > This may be more of a postgresql question, but it is related to my postgis > setup. I was hoping that someone might know of an easy way to l

[postgis-users] tool to load dbf into postgresql table

Hello, This may be more of a postgresql question, but it is related to my postgis setup. I was hoping that someone might know of an easy way to load a dbf into postgresql table. I have used the gdal tool shp2pgsql to load a shapefile in this way and it worked great. Is there a similar tool for l