Re: Renaming Raster Table

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>