Hi allwin2002au,
The public.geometry_columns table will be populated if a layer is load with postgis geometry type. When you loaded data in ArcCatalog did you indicate the PG_GEOMETRY keyword? If you did not, and you did not alter the defaults in the dbtune table, than ArcCatalog will load with the GEOMETRY keyword by default with is the ESRI type.
Is there a record in the sde_layers table for the data you loaded? but no public. geometry_columns entry? Than that is most likely what had happened.
Sincerely,
Kasia