[postgis-users] How to create a geographic view

[Ezequias Rodrigues da Rocha]

I create a view with all attributes but with a subset of the main layer. 
It still does not appears on  the geoserver.

I am worried about it yet.

Could you tell me if is possible to make an export to PostGIS by using 
only Java ?

Ezequias


Nicolas Ribot escreveu:
>> Hi list,
>>
>> I was trying to create a view of my map to access a wfs services. The
>> problem is that we couldn't see it at Geoserver why ?
>>
>> Becouse I did a PostgreSQL view of my map.
>>
>> I need to know how to make a new postgis table view based on a existed
>> postgis table.
>>
>> Any suggestion would be glad.
>>
>> Sincerely...
>>
>>     
>
> Hi,
>
> You should be able to create your view from your gis table, then
> updating the geometry_columns table to add information about this view
> to allow external programs to be aware of this geographic view.
>
> Use an insert command like this one to add a new entry in geometry_columns:
>
> insert into geometry_columns
> (f_table_schema, f_table_catalog, f_table_name, f_geometry_column,
> srid, type, coord_dimension)
> values
> ('', '', 'my_view', 'the_geom', <my_srid>, 'GEOMETRY', 2);
>
> It worked, for example, in OpenJump.
>
> Nicolas
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   

-- 
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com
msn:ezequias at hotmail.com
"the worst of democracies is still better than the best of dictatorship"