从其他数据库插入表
|
的SQL
INSERT INTO t_publikasi
(\"idPublikasi\",\"kdBahanPustaka\",\"bulanTerbit\", \"tahunTerbit\", \"noUrutBI\",
\"pdfDir\", \"judul\")
SELECT *
FROM dblink(\'dbname=perpus2 port=5432 user=dbdev password=develop\',
\'SELECT \'113\' || substring(\"no_pustaka\",4,2) as bb ||
substring(\"no_pustaka\",6,2) as cc ||
substring(\"no_pustaka\",9,4) as dd,
\'113\',
substring(\"no_pustaka\",4,2) as bb,
substring(\"no_pustaka\",6,2) as cc,
substring(\"no_pustaka\",9,4) as dd,
\"file_pdf\",\"judul\"
FROM kuesioner
ORDER BY bb, cc, dd\') AS kuesioner (
id varchar(10),
kd varchar(10),
bln varchar(10),
thn varchar(10),
urut varchar(10),
file_pdf varchar(50),
judul varchar(50));
ERROR: syntax error at or near \"113\"
LINE 1: ...2 port=5432 user=dbdev password=develop\',\'SELECT \'113\' || su...
^
ERROR: syntax error at or near \"113\"
SQL state: 42601
没有找到相关结果
已邀请:
3 个回复
磐去裸猜饲
芭隘的盘石
之所以有效，是因为它将选择一个数字而不是字符文字。 然后，“ 4”运算符会将其静默转换回字符值。 在字符文字中嵌入单引号的正确方法是编写两个单引号：痴浪墨
... FROM dblink(\'dbname=perpus2 port=5432 user=dbdev password=develop\', $my_dblink_arg$SELECT \'113\' || ... FROM kuesioner ORDER BY bb, cc, dd$my_dblink_arg$) AS kuesioner ...