[postgis-users] my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR

[cPanel cPanel]

Thanks by your instructions and patience.

In my server, AFTER of I run the command:

yum -y install postgis31_13

I run the commands:

CREATE EXTENSION postgis;
CREATE EXTENSION postgis_raster;
CREATE EXTENSION postgis_topology;
CREATE EXTENSION postgis_sfcgal;
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION address_standardizer;
CREATE EXTENSION address_standardizer_data_us;
CREATE EXTENSION postgis_tiger_geocoder;

after I restart postgres

after I run:

SELECT PostGIS_Version();
RESULT =   => 3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

then I run the command :
SELECT num, street, city, state, zip FROM parse_address('1 Devonshire
Place PH301, Boston, MA 02109');
RESULT = stdClass Object
(
    [num] => 1
    [street] => Devonshire Place PH301
    [city] => Boston
    [state] => MA
    [zip] => 02109
)

then when I run the command:
SELECT superhero.name FROM city, superhero WHERE
ST_Contains(city.geom, superhero.geom) AND city.name = 'Gotham';
RESULT = ERROR:  relation "city" does not exist


by now I not run any command more.

for my is confuse: commands 1 and 2 RESULT = values!,
command #3 RESULT = error.

what I need do?
my DB postgis is incomplete?
or...
my commands are wrong?

with which command I cnfirm POSTGIS is ready to use?


logically I am VERY new in this.


Many thanks again.













2021-09-12 18:09 GMT-05:00, Gary Turner <g at elizr.com>:
> Does your database on your server contain that data?
> That is just an example, it won't work if you don't have the correct
> data in those tables on your server.
>
> On 13/09/2021 2:54 am, cPanel cPanel wrote:
>> hello
>>
>> I have 4 results from QUERYS in my CentOs 7 + PostgreSQL 13.4 on
>> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
>> 4.8.5-44), 64-bit
>>
>> I connect as USER postgres
>>
>> QUERY 1:
>> SELECT PostGIS_Version();
>>   => 3.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
>>
>>
>> QUERY 2:
>> SELECT PostGIS_Full_Version();
>> => POSTGIS="3.1.4 ded6c34" [EXTENSION] PGSQL="130"
>> GEOS="3.9.1-CAPI-1.14.2" SFCGAL="1.3.1" PROJ="7.2.1" GDAL="GDAL 3.3.1,
>> released 2021/06/28" LIBXML="2.9.1" LIBJSON="0.11" TOPOLOGY RASTER
>>
>> QUERY 3:
>> SELECT num, street, city, state, zip FROM parse_address('1 Devonshire
>> Place PH301, Boston, MA 02109');
>>      [num] => 1
>>      [street] => Devonshire Place PH301
>>      [city] => Boston
>>      [state] => MA
>>      [zip] => 02109
>>
>> now my problem in QUERY 4:
>> a// I open http://postgis.net/
>> b// I copy exactly "the command test" from home page:
>> QUERY = SELECT superhero.name FROM city, superhero WHERE
>> ST_Contains(city.geom, superhero.geom) AND city.name = 'Gotham';
>> c// I run QUERY in my server
>> d// result is:
>>
>> ----------------------------------------------------------------------------------------------------------------------
>>      [pg_last_error()] => ERROR:  relation "city" does not exist
>> LINE 1: SELECT superhero.name FROM city, superhero WHERE ST_Contains...
>> ----------------------------------------------------------------------------------------------------------------------
>>
>> why this error?
>> how I can fix?
>>
>> my target is OTHERS users (not postgres) can use POSTGS
>> then how can user1, user2, user33 use POSTGIS without connect to DB
>> postgres ??
>> or... to use POSTGIS is mandatory users connect to postgres DB ?
>>
>>
>>
>>
>> many thanks
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>