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]', '+554999999999', 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 list
>         [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

Responder a