how to count the number of characters in a postgres database

• nneka echebe

  SSC Enthusiast

  Points: 106

  More actions

  April 25, 2008 at 8:09 am

  #185780

  Hi,

  I have a postgres database and I am trying to find out the longest character in the text field name

  I tried using

  select length(table.column) but it is returning wrong figures

  Can anyone help me out?

  Cheers

  Nneka

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  April 25, 2008 at 9:44 am

  #807265

  This site is for SQL Server - you need a different site. Try this one...

  http://www.dbforums.com/forumdisplay.php?forumid=81

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.