Como mostra a figura, o nome da coluna é *klm*traveled e você fez o insert
usando *kml*traveled.





--
Everton

On Tue, Dec 16, 2014 at 5:07 PM, Matheus Saraiva <[email protected]>
wrote:
>
>  http://oi57.tinypic.com/i1mmua.jpg
>
> Em Ter, 2014-12-16 às 16:58 -0200, Everton Berz escreveu:
>
> Qual a saída de:
>
>  SELECT column_name, length(column_name) FROM information_schema.columns
> WHERE table_schema = 'operational' AND table_name   = 'technical';
>
>
>
>  ?
>
>
>  --
> Everton
>
>
>  On Tue, Dec 16, 2014 at 4:50 PM, Matheus Saraiva <
> [email protected]> wrote:
>
>  O que há de errado com esse insert?:
>
> *insert into operational."technical"(fullname, email, phone, image,
> kmltraveled) values('Teste de inserção Manual', '[email protected]
> <'[email protected]>', '+554999999999 <%2B554999999999>', NULL,
> 0.0);*
>
> Recebo o seguinte erro:
>
> ERROR:  column "kmltraveled" of relation "technical" does not exist
>             LINE 1: ...tional."technical"(fullname, email, phone, image,
> kmltravele..
>
> A coluna existe na tabela technical e o nome está correto
>
>   _______________________________________________
> pgbr-geral mailing 
> [email protected]https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
>
>
>     --
> *Matheus Saraiva da Silva*
> *Chapecó - SC*
>
> _______________________________________________
> 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

Responder a