kingbaseES V8R3 图片数据存储测试

kingbaseES V8R3 图片数据存储测试

TEST=# select version();
                                                      version
----------------------------------------------------------------------------------------------------------
 Kingbase V008R003C002B0061 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-46), 64-bit
(1 row)

1、图片数据

[root@node03 kingbase]# ls -lh f02.PNG
-rw-r--r-- 1 kingbase kingbase 26K 2月   2 16:41 f02.PNG

2、查看blob函数

prod=# select proname from sys_proc where proname like '%blob%';
   proname
-------------
 EMPTY_BLOB
 BLOB_IMPORT
 BLOB_EXPORT
(3 rows)

3、创建测试表
prod=# create table pt1 ( id int ,tpic bytea ,err varchar(20));
CREATE TABLE
prod=# \d pt1;
               Table "PUBLIC.pt1"
 Column |            Type            | Modifiers
--------+-