算法，时空数据挖掘

As I said yesterday that I tried to create a remote PostgreSQL database on the Ubuntu Server hosted by DigitalOcean. After I created the PostgreSQL, I met some problems connecting to the remote databa

There is an article[1] for installing PostgreSQL on Ubuntu. [2] actually is a even better one if you want to install PostgreSQL and PostGIS at the same time.   In order to use PostGIS in database, yo

There are a few special sql commands that I used often recently, mark them here. 1: Show all the columns' name SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='yourtablename';

Currently I want to transfer all my local database to the remote server and I found a very simple solution.   (1) Backup your database [1]   (2) Transfer the backup to the destination server.   (3)

Today I tried to install the postgresql on the ubuntu server hosted by the digital ocean like[1]. It should be a quite easy task. But I kept getting errors when I typed the command "psql", the error s