Thank you very much for all. Now everything is OK. I load PostGIS functions with 'lwpostgis.sql' into my DB, and all it's OK.
Now, I have created a geometric column and using geometryfromtext I have introduced all the POINTS. Thanks again... Javier Estévez > ¡Hola Javier! > > Maybe you did not create your database properly... > > from http://www.postgis.org/documentation/ > > createlang plpgsql postgres > psql -d postgres -f lwpostgis.sql > psql -d postgres -f spatial_ref_sys.sql > > the two scripts could be in a number of places on your system: if you > built postgis from source, in your build directory, or maybe in > /usr/share/postgresql/8.3/contrib, or... you might have to look around a > bit :-) > > [EMAIL PROTECTED] wrote: >> I tried one thing: >> >> I create a new table in the database including PostGIS functions. This query >> is CORRECT now: >> >> SELECT addgeometrycolumn('public','tablenew','the_geom',23030,'POINT',2) >> >> The problem right now is... How can I import the PostGIS functions into my >> DATABASE?????? >> >> >>> The function is there and executing, however it is complaining that it >>> cannot find the table name in the public schema. >>> >>> What was your original table create statement for the "estac_aemet" >>> table? "CREATE TABLE public.estac_aemet (field type, etc... " >>> Did you use special accent characters in its creation? >>> >>> >>> >>>> -----Original Message----- >>>> From: [EMAIL PROTECTED] >>>> [mailto:[EMAIL PROTECTED] On >>>> Behalf Of [EMAIL PROTECTED] >>>> Sent: Wednesday, August 27, 2008 8:13 AM >>>> To: PostGIS Users Discussion >>>> Cc: PostGIS Users Discussion >>>> Subject: Re: [postgis-users] AddGeometryColumn error >>>> >>>> >>>> Correctly, I have 3 databases: postgres (This my DB), >>>> demo_postgis and template_postgis >>>> >>>> In my DB there is no FUNCTIONS >>>> In template_postgis there are all the POSTGIS functions. >>>> >>>> Can I import from 'my DB' all PostGIS functions that are in other DB >>>> (template_postgis) >>>> >>>> Thanks. >>>> >>>> >>>>> Hi, >>>>> >>>>> maybe your instalation of postgis functions and etc are not in >>>>> postgres db. If you are using windwos search for others databases, >>>>> maybe a postgis or postgis_template. At that databases you >>>>> >>>> will find >>>> >>>>> the the functions. >>>>> >>>>> If you are using linux then you will have to add that functions to >>>>> some database, see the docs for a how-to. >>>>> >>>>> A good policy is to create a new database using a template with the >>>>> postgis stuff. Leave the postgres db for maintenance. >>>>> >>>>> Best regards, >>>>> >>>>> 2008/8/27 <[EMAIL PROTECTED]> >>>>> >>>>> >>>>>> No, is correct like 'estac_aemet' >>>>>> >>>>>> How do I know if my POSTGIS functions are installed ok? >>>>>> >>>>>> In my DB called 'postgres' I have no Functions. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>>>> Yes, the tabla estac_aemet exists. The schema is public >>>>>>>> >>>>>>>> >>>>>>> Did you create the table using double quotes to name it ? >>>>>>> "ESTAC_AEMET" >>>>>>> >>>>>> maybe >>>>>> >>>>>>> ? >>>>>>> If so, then you have to respect the case in the table name when >>>>>>> naming >>>>>>> >>>>>> it: >>>>>> >>>>>>> SELECT addgeometrycolumn('public','ESTAC_AEMET', 'the_geom', >>>>>>> >>>>>> 23030,'POINT',2) >>>>>> >>>>>>> You can check the table name by launching psql and typing \d to >>>>>>> list all tables. >>>>>>> >>>>>>> >>>>>>> Nicolas >>>>>>> _______________________________________________ >>>>>>> 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 >>>>>> >>>>>> >>>>> >>>>> -- >>>>> Luigi Castro Cardeles >>>>> >>>> _______________________________________________ >>>> >>>>> 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 >>> >>> >> >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> > > > -- > Regards, > > Chris Hermansen mailto:[EMAIL PROTECTED] > tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.232.0644 > Timberline Natural Resource Group · http://www.timberline.ca > 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5 > > _______________________________________________ > 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
