Welcome to Sign in | Help

Re: replicare SQL Server si Postgresql

  •  02-12-2008, 3:57 PM

    Re: replicare SQL Server si Postgresql

    cretzu:

    Am incercat ceva de genu

    SELECT * FROM PGSLAVE.slave.[public].tab1

    dar tot imi da eroare nu ii place chestia asta cu public desi .. pe postgresql schema defautl asa se numeste :(


    Ok.
    Da' creaza-ti o schema in PG si apoi tabela o creezi de asemenea in schema respectiva:

    CREATE SCHEMA myschema;

    CREATE TABLE myschema.mytable (
    ...
    );

    --si apoi

    SELECT *
    FROM server.bazadedate.myschema.mytable

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems