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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of [EMAIL PROTECTED] > 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: [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 > postgis-users@postgis.refractions.net > >> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users > >> >> > > >> >> > >> >> > >> >> _______________________________________________ > >> >> postgis-users mailing list postgis-users@postgis.refractions.net > >> >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> >> > >> > > >> > > >> > > >> > -- > >> > Luigi Castro Cardeles > >> _______________________________________________ > >> > postgis-users mailing list postgis-users@postgis.refractions.net > >> > http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > >> > >> > >> _______________________________________________ > >> postgis-users mailing list postgis-users@postgis.refractions.net > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > > _______________________________________________ > > postgis-users mailing list postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users