I get a relation "nqaatt" does not exist. I changed the sql to show
storm cells in the tornadowarning, it works fine in the pgAdmin III
tool area here is the sql statement
SELECT DISTINCT ON (ncities.name)
ncities.name, ncities.the_geom
FROM ncities INNER JOIN torpoly ON ST_Within(ncities.the_geom,
torpoly.the_geom)
ORDER BY ncities.name
the command I am using is psql -f run.psql
On Tue, May 6, 2008 at 12:12 PM, Burgholzer,Robert
<[EMAIL PROTECTED]> wrote:
> You want to run that command with the "-f" switch, the "-c" switch is
> for a single command, not a script file.
>
> HTH
>
> Robert W. Burgholzer
> Surface Water Modeler
> Office of Water Supply and Planning
> Virginia Department of Environmental Quality
> [EMAIL PROTECTED]
> 804-698-4405
> Open Source Modeling Tools:
> http://sourceforge.net/projects/npsource/
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> chris brisendine
>
>
> Sent: Tuesday, May 06, 2008 11:35 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Points with in multiple Polygons
>
> Great Idea on the tornado intersect it does from time to time! It
> worked great ! thanks, maybe one day it can save a life, If i wanted
> to run the query from the command line would i use the psql -c
> run.psql to output a list to a txt file? im getting a error with that
> ERROR: syntax error at or near "run" at character 1
> LINE 1: run.psql
> Thanks alot your time is very appreciated!
>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
