Create table a(id int,name varchar(20)); Insert into a values(1,’a’); Insert into a values(2,’b’); Insert into a values(3,’c’); 修改 kingbase.conf 文件中shared_preload_libraries 添加shared_preload_libraries = 'cstore_fdw' Create extension cstore_fdw; Create server cstore_server foreign data wrapper cstore_fdw; Load cstore_fdw; Create foreign table b(in int,name varchar(20))server cstore_server options(compression ‘pglz’); |
Insert into b select * from a;