[postgis-users] AddGeometryColumn error

[Sufficool, Stanley]

The easiest way is to create your database using the template_postgis as
the template database.

The "after the fact" way is to execute the SQL script located at
\Program Files\PostgreSQL\8.3\share\contrib\lwpostgis.sql (For windows
installations)

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of javier.estevez.ext at juntadeandalucia.es
> Sent: Wednesday, August 27, 2008 10:23 AM
> To: PostGIS Users Discussion
> Cc: PostGIS Users Discussion
> Subject: RE: [postgis-users] AddGeometryColumn error
> 
> 
> 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: postgis-users-bounces at postgis.refractions.net
> >> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of 
> >> javier.estevez.ext at juntadeandalucia.es
> >> 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 <javier.estevez.ext at juntadeandalucia.es>
> >> >
> >> >> 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 
> postgis-users at postgis.refractions.net
> >> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >> >
> >> >>
> >> >>
> >> >> _______________________________________________
> >> >> postgis-users mailing list postgis-users at postgis.refractions.net
> >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >>
> >> >
> >> >
> >> >
> >> > --
> >> > Luigi Castro Cardeles
> >> _______________________________________________
> >> > postgis-users mailing list postgis-users at postgis.refractions.net
> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >> >
> >>
> >>
> >> _______________________________________________
> >> postgis-users mailing list postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>