Renaming Raster Table

On Thu, Jul 6, 2017 at 8:52 AM, Osahon Oduware <osahon.gis@gmail.com> 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*.

​While you may get a response here the PostGIS project appears to host its
own mailing lists and you might find you get a faster/better response if
you ask this very product specific question over there.

David J.

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.klaver@aklaver.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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.klaver@aklaver.com>
wrote:

Hi David,

Thanks, I have done so.

On Thu, Jul 6, 2017 at 5:05 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote: