Mega Code Archive

 

Categories / PostgreSQL / Data Type

 

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=#