Hi Adrian, 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*.
On Thu, Jul 6, 2017 at 6:27 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 07/06/2017 08:52 AM, Osahon Oduware wrote: > >> Hi All, >> >> 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*. >> >> > The docs seem to cover this: > > http://postgis.net/docs/manual-2.2/using_raster_dataman. > html#RT_Raster_Loader > > "-l OVERVIEW_FACTOR > > 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. > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >