Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- begin{lstlisting}[
- language=SQL,
- caption={Exemplo de Exportação para CSV de um Vértice},
- label=lst:experimentos_exporta_vertice,
- showspaces=false,
- basicstyle=ttfamily,
- numbers=left,
- numberstyle=tiny,
- commentstyle=color{gray}
- ]
- CREATE TEMP SEQUENCE seq_tmp; /* cria um sequence para gerar um id sequencial servir de pk */
- CREATE TEMP TABLE exporta_vertice AS /* tabela temporária */
- SELECT NEXTVAL('seq_tmp') AS aux_pk, /* geração da pk - de_pk será o nome da coluna no arquivo*/
- TO_CHAR(CAST(aux_dt AS DATE), 'YYYY/mm/DD') AS aux_data,
- TO_CHAR(CAST(aux_hora AS TIME), 'HH24:MI') AS aux_hora,
- TO_CHAR(aux_float*100, '999''.''99') AS aux_float,
- aux_string6,
- aux_integer3 AS aux_int3
- FROM arquivo
- ORDER BY 1;
- COPY exporta_vertice TO 'E://diretorio//exemplo_vertice.csv' HEADER CSV FORCE QUOTE;
- DROP TABLE exporta_vertice;
- DROP SEQUENCE seq_tmp;
- end{lstlisting}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement