CREATE INDEX

create_index.sql

SELECT 'CREATE INDEX ' || quote_ident(f_table_name || '_geom_idx') || ' ON ' || quote_ident(f_table_schema) || '.' || quote_ident(f_table_name) || ' USING GIST (' || quote_ident(f_geometry_column) || ');' AS SQL
FROM geometry_columns
WHERE f_table_name IN ('topographicarea',
                       'topographicline');

results.txt

                                              sql                                               
------------------------------------------------------------------------------------------------
 CREATE INDEX topographicarea_geom_idx ON osmm_topo2.topographicarea USING GIST (wkb_geometry);
 CREATE INDEX topographicline_geom_idx ON osmm_topo2.topographicline USING GIST (wkb_geometry);
 CREATE INDEX topographicline_geom_idx ON osmm_topo.topographicline USING GIST (wkb_geometry);
 CREATE INDEX topographicarea_geom_idx ON osmm_topo.topographicarea USING GIST (wkb_geometry);

Awesome!! This worked perfectly, thanks!!
(Mental note: brush up on SQL skills.....)