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.raja...@gmail.com> > Para: pgsql-general@postgresql.org, pgsql-...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general