Obrigado pelas dicas. (RESOLVIDO) Atenciosamente,
Alessandro Lima Em 25 de janeiro de 2012 14:22, JotaComm <[email protected]> escreveu: > Opa, > > > > Em 25 de janeiro de 2012 14:14, Alessandro Lima > <[email protected]>escreveu: > > Já estou utilizando view conforme exemplo abaixo, porém quando reinicio o >> banco a conexão é perdida. > > > >> >> CREATE VIEW Cidade AS >> SELECT * FROM dblink('conexao1', >> 'SELECT * FROM Cidade') AS resultado ( >> estado INTEGER, nome VARCHAR(50), cep VARCHAR(10), >> codigoIBGE VARCHAR(20), codigo INTEGER); >> >> conexao1 é a conexão criada pelo: >> SELECT >> dblink_connect('conexao1', 'hostaddr=127.0.0.1 port=5432 dbname=TESTEBD >> user=postgres password=postgres'); >> > > Faça o seguinte: > > CREATE VIEW Cidade AS > SELECT * FROM dblink(' > hostaddr=127.0.0.1 port=5432 dbname=TESTEBD user=postgres password=postgres > ', > 'SELECT * FROM Cidade') AS resultado ( > estado INTEGER, nome VARCHAR(50), cep VARCHAR(10), > codigoIBGE VARCHAR(20), codigo INTEGER); > > >> Atenciosamente, >> >> Alessandro Lima >> >> >> >> Em 25 de janeiro de 2012 11:55, JotaComm <[email protected]> escreveu: >> >> Opa, >>> >>> Em 25 de janeiro de 2012 11:52, Alessandro Lima <[email protected] >>> > escreveu: >>> >>> Preciso fazer consultas usando join entre tabelas de base de dados >>>> diferentes. >>> >>> >>> Que tal fazer isso via uma view? >>> >>>> >>>> Atenciosamente, >>>> >>>> Alessandro Lima >>>> >>>> >>>> >>>> Em 25 de janeiro de 2012 10:53, JotaComm <[email protected]>escreveu: >>>> >>>> Olá, >>>>> >>>>> Em 25 de janeiro de 2012 10:09, Alessandro Lima < >>>>> [email protected]> escreveu: >>>>> >>>>> Estou iniciando a utilizar dblink, gostaria de uma dica de como criar >>>>>> automaticamente uma conexão ao reiniciar o servidor do postgres, >>>>>> pois sempre que reinicio o servidor tenho que criar a seguinte >>>>>> conexão: >>>>>> >>>>>> SELECT >>>>>> dblink_connect('conexao1', 'hostaddr=127.0.0.1 port=5432 dbname=TESTEBD >>>>>> user=postgres password=postgres'); >>>>>> >>>>> >>>>> Qual o objetivo disso? >>>>> >>>>>> >>>>>> Atenciosamente, >>>>>> >>>>>> Alessandro Lima >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> pgbr-geral mailing list >>>>>> [email protected] >>>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>>> >>>>>> >>>>> >>>>> Abraços >>>>> -- >>>>> JotaComm >>>>> http://jotacomm.wordpress.com >>>>> >>>>> _______________________________________________ >>>>> pgbr-geral mailing list >>>>> [email protected] >>>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> pgbr-geral mailing list >>>> [email protected] >>>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>>> >>>> >>> >>> Abraços >>> -- >>> JotaComm >>> http://jotacomm.wordpress.com >>> >>> _______________________________________________ >>> pgbr-geral mailing list >>> [email protected] >>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> > > Abraços > -- > JotaComm > http://jotacomm.wordpress.com > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
