Create table with point data type : Point « Data Type « PostgreSQL






  1. PostgreSQL
  2. Data Type
  3. Point

Create table with point data type


postgres=# CREATE TABLE cities (
postgres(#    name            varchar(80),
postgres(#    location        point
postgres(# );
CREATE TABLE
postgres=#
postgres=# drop table cities;
DROP TABLE
postgres=#
postgres=#








Related examples in the same category

1.Use Point data type in insert statement
2.Using Point data type in a function
3.Using point data type in insert statement