public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: cPanel cPanel <[email protected]>
To: [email protected]
Subject: Re: my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR
Date: Sun, 12 Sep 2021 20:14:36 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+2wNPZyr4Agm-X+qyP4Pp-DgT6V+ERCGTFbMuNjn_onQGcJtA@mail.gmail.com>
References: <CA+2wNPZyr4Agm-X+qyP4Pp-DgT6V+ERCGTFbMuNjn_onQGcJtA@mail.gmail.com>
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
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: my server return OK with ALL, but QUERY.test from HOME http://postgis.net return ERROR
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox