Thanks for your response. I have already loaded the raster, but I want to rename the raster table and I am asking of how to do this without affecting the functionality of the raster/overviews.
I used the raster2pgsql tool to load a raster with overviews into a PostGIS database using the following format: raster2pgsql -s <SRID> -d -Y -e -I -C -F -M -l 2,4,8,16 /path/to/raster/file <table_name> | psql -h <host_address> -U postgres -p 5432 -d <database>
Now, *I want to rename the raster table and I would like to know the affected tables and the required changes to be done without affecting the functionality of the raster/overviews*.
Create overview of the raster. For more than one factor, separate with comma(,). Overview table name follows the pattern o_overview factor_table, where overview factor is a placeholder for numerical overview factor and table is replaced with the base table name. Created overview is stored in the database and is not affected by -R. Note that your generated sql file will contain both the main table and overview tables."
In addition it is going to produce an SQL file that contains the changes for you to look at.