스키마 수정

In PostGIS, for points with latitude and longitude there is geography datatype. To add a column: alter table your_table add column geog geography; To insert data: insert into your_table (geog) values ('SRID=4326;POINT(longitude latitude)'); 4326 is Spatial Reference ID that says it's data in degrees longitude and latitude, same as in GPS.

The GIS objects supported by PostGIS are all the vector types defined in the "Simple Features for SQL 1.2.1" standard defined by the OpenGIS Consortium (OGC), and the ISO "SQL/MM Part 3: Spatial" document. In addition, PostGIS supports a raster type (no standards exist to follow), and a topology model (following an early draft ISO standard for topology that has not been published as yet).

Assuming this table: CREATE TABLE students ( student_id SERIAL PRIMARY KEY, player_name TEXT ); There are four different ways to define a foreign key (when dealing with a single column PK) and they all lead to the same foreign key constraint: Inline without mentioning the target column: CREATE TABLE tests

Summary: in this tutorial, you will learn about PostgreSQL foreign key and how to add foreign keys to tables using foreign key constraints. A foreign key is a column or a group of columns in a table that reference the primary key of another table.