Continents / Countries border PostGIS (Polygon vs Linestring)

Question

I would like to insert a polygon containing Europe into my PostGIS database.

I have the following extreme points:

NW = NorthWest Border (lat = 82.7021697 lon = -28.0371000)

NE = NorthEast Border (lat = 82.7021697 lon = 74.1357000)

SE = SouthEast Border (lat = 33.8978000 lon = 74.1357000)

SW = SouthWest Border (lat = 33.8978000 lon = -28.0371000)

Is a valid polygon:

POLYGON ((NWLon NWLat, NELon NELat, SELon SElat, SWLon SWLat, NWlon NWLat))

Is this a valid polygon?

I see several polygons followed by the POLYGON ((), ()) format? When are they used?

Why not linestring?

Any help would be appreciated? It scares me.

thank

Answer 1

PostGIS:

ST_GeomFromText('POLYGON((lon1 lat1, lon2 lat2, ... lonN latN))', SRID)

SRID - SRID , , lonN, latN lon1, lat1, .

Postgres (.. , , ); :

insert into some_table (polygon_column) values ('(1,1),(2,2),(3,4),(1,1)');

: SQL- PostgreSQL.