Thread: [GENERAL] Renaming Raster Table
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.
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
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:
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
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:
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.