On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote: > Hi all - > > I am trying to write a query to find all the column names in > database that has a underscore in it (_) example souce_id. I know like will > not work , if where column_name like '%_%' Can you please help?
where column_name ~ '_' Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
