Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO discente
- (rga,anoing,bairro,ncelular,compl,cpf,dtnasc,email,endereco,fone,nomemae,natcid,nome,rgnum,titelnum,nomepai,titelsec,titelzon
- ,centro,curso,natuf,titeluf,codtipoing)
- (SELECT * FROM dblink('host=localhost port=5432 dbname=siscad user=postgres password=root',
- 'SELECT
- a."academicoRga"
- , a."academicoAnoIngresso"
- , a."academicoBairro"
- , a."academicoCelular"
- , a."academicoComplemento"
- , a."academicoCpf"
- , a."academicoDtNasc"
- , a."academicoEmail"
- , a."academicoEndereco"
- , SUBSTR(a."academicoFone",1,15)
- , a."academicoMae"
- , a."academicoNatCid"
- , a."academicoNome"
- , SUBSTR(a."academicoNumRg",1,15)
- , a."academicoNumTitulo"
- , a."academicoPai"
- , a."academicoSecaoTitulo"
- , a."academicoZonaTitulo"
- , a."centroId"
- , a."cursoId"
- , a."ufSiglaNaturalidade"
- , a."ufSiglaTitulo"
- , ts."tipoSituacaoTipo"
- FROM "public".academico a
- inner join ocorrencia o
- on o."academicoId"=a."academicoId"
- left join "tipoSituacao" ts
- on ts."tipoSituacaoId"=o."tipoSituacaoId"
- where a."academicoSituacao"=\'I\' and ts."tipoSituacaoTipo"=\'ING\' ')
- AS siscad(academicoRga VARCHAR,
- academicoAnoIngresso SMALLINT,
- academicoBairro VARCHAR,
- academicoCelular VARCHAR,
- academicoComplemento VARCHAR,
- academicoCpf VARCHAR,
- academicoDtNasc DATE,
- academicoEmail VARCHAR,
- academicoEndereco VARCHAR,
- academicoFone VARCHAR,
- academicoMae VARCHAR,
- academicoNatCid VARCHAR,
- academicoNome VARCHAR,
- academicoNumRg VARCHAR,
- academicoNumTitulo VARCHAR,
- academicoPai VARCHAR,
- academicoSecaoTitulo VARCHAR,
- academicoZonaTitulo VARCHAR,
- centroId SMALLINT,
- cursoId SMALLINT,
- ufSiglaNaturalidade VARCHAR,
- ufSiglaTitulo VARCHAR,
- tipoSituacaoTipo VARCHAR)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement