public inbox for [email protected]
help / color / mirror / Atom feedmy server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR
2+ messages / 2 participants
[nested] [flat]
* my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR
@ 2021-09-12 15:51 cPanel cPanel <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: cPanel cPanel @ 2021-09-12 15:51 UTC (permalink / raw)
To: [email protected]
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR
@ 2021-09-12 18:14 Laurenz Albe <[email protected]>
parent: cPanel cPanel <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Laurenz Albe @ 2021-09-12 18:14 UTC (permalink / raw)
To: cPanel cPanel <[email protected]>; [email protected]
On Sun, 2021-09-12 at 10:51 -0500, cPanel cPanel wrote:
> 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?
Initially, PostgreSQL databases are empty and contain no data (except metadata).
There is certainly no table like "city" or "superhero".
Before you can query these tables, you have to create them and fill them with data.
If you follow a tutorial, that tutorial should tell you how to get these data and
how to load them into your database.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-09-12 18:14 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-09-12 15:51 my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR cPanel cPanel <[email protected]>
2021-09-12 18:14 ` Laurenz Albe <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox