[postgis-users] AddGeometryColumn error

[javier.estevez.ext at juntadeandalucia.es]

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
>