Re: [udig-devel] Can uDig plot PostGIS data from an SQL view?

[Cory Horner <chorner@xxxxxxxxxxxxxxx>]

Cory Horner wrote:

> Gary Lucas wrote:
>
> > I am trying to use uDig 1.1.RC4 to view a subset of records from a 
> > Postgres table. The table contains 50 or 60 thousand records, I'm try 
> > to view a few hundred. I am interested in doing this on a read-only 
> > basis, using uDig as a data-inspection tool, so editing doesn't come 
> > into play. I didn't see any way to accomplish this through the style 
> > specifications (putting aside overhead issues, the query I use to 
> > develop the subset depends on the SQL LIKE operation).  Anyway, I had 
> > the idea of creating an
> > SQL View and reading the data from the view rather than from the 
> > actual table.
> >
> > The uDIG GUI recognizes the SQL view and allows me to add it to a map.
> > Unfortunately, uDig does not appear to pull back any data.  Nothing 
> > plots and
> > I get a zero feature count.
> >
> > Did I miss a procedure?  Do I have to do something extra in PostGIS to
> > enable it to identify the geometry attribute in the SQL view? 
Props to Jesse for the absolutely gorgeous feature in 1.1.RC5 that tells 
the user they don't have permission to read a table :)

Here are the steps I used to make this work:

CREATE VIEW grnf_view AS SELECT * FROM grnf059r06a_e WHERE type = 'RD';

GRANT SELECT ON TABLE grnf_view TO test;

INSERT INTO geometry_columns VALUES 
('','public','grnf_view','the_geom',2,4269,'MULTILINESTRING');

Cheers,
Cory.