先介绍一下Postgresql的建索引语法: Version:9.1 1.CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table [ USING method ] 2. ( { column | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] ) 3. [ WITH ( storage_parameter = value [, ... ] ) ] 4.