PostgreSQL数据库图像搜索插件imgsmlr部署

https://github.com/postgrespro/imgsmlr

1、deploy
   

apt-get install postgresql-server-dev-all
   apt-get install postgresql-common
   apt-get install libgd2-noxpm-dev

2、compile
   

$ git clone https://github.com/postgrespro/imgsmlr.git
   $ cd imgsmlr
   $ make USE_PGXS=1
   $ sudo make USE_PGXS=1 install
   $ make USE_PGXS=1 installcheck

   
3、Enter Database: postgres=#
 

CREATE EXTENSION imgsmlr;

  
4、Search Example:
 

1)CREATE TABLE pat AS ( SELECT name, shuffle_pattern(pattern) AS pattern,pattern2signature(pattern) AS signature FROM (SELECT name, jpeg2pattern(content) AS pattern FROM cataract) x );
 2)ALTER TABLE pat ADD PRIMARY KEY (name);
 3)CREATE INDEX pat_signature_idx ON pat USING gist (s