I guess that could need something like (untested)
delete from bigtable text_column !~ '^[0-9][0-9]*$';
HTH
Gerardo
----- Mensaje original -----
> De: "Suresh Raja" <suresh.rajaabc@gmail.com>
> Para: pgsql-general@postgresql.org, pgsql-sql@postgresql.org
> Enviados: Viernes, 27 de Marzo 2015 15:08:43
> Asunto: [SQL] check data for datatype
>
>
>
>
>
>
>
>
> Hi All:
>
>
> I have a very large table and the column type is text. I would like
> to convert in numeric. How can I find rows that dont have numbers. I
> would like to delete those rows.
>
>
> Thanks,
> -Suersh Raja