1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| createdb MSSQL
createlang plperlu MSSQL
psql -f dbi_link.sql MSSQL
UPDATE
pg_catalog.pg_settings
SET
setting =
CASE WHEN 'dbi_link' = ANY(string_to_array(setting, ','))
THEN setting
ELSE 'dbi_link,' || setting
END
WHERE
name = 'search_path'
;
SELECT dbi_link.make_accessor_functions(
'dbi:Sybase:database=DATABASE;server=X.X.X.X;port=1433'::dbi_link.data_source,
'user'::text,
'password'::text,
'---
AutoCommit: 1
RaiseError: 1
'::dbi_link.yaml,
NULL::dbi_link.yaml,
NULL::text,
NULL::text,
'MerlinNORM'::text
);
SELECT * FROM dbi_link.refresh_schema(1) => voir l'indice dans la table dbi_connection
SELECT * FROM DATABASE."TABLE" |