Loading rasters into PostgreSQL

To load a raster into PostgreSQL, you can use the raster2pgsql binary. If it is not in your path, you may need to add it. You should be able to find the binary in your PostgreSQL install directory on Windows at PostgreSQL10in.

The following command should be executed from your operating system's command line. It will load the TIF you created earlier in this chapter into an existing PostgreSQL database:

>raster2pgsql -I -C -s 4326 C:UsersPaulDesktopBigI.tif public.bigi | psql -U postgres -d pythonspatial

The previous command uses raster2pgsql with the -I (creates an index), -C (adds raster constraints), and -s 4326 (the SRID) parameters. Using the pipe operator on Windows, you send the command to psql. Psql is run using the -U postgres (username) and -d pythonspatial (database) parameters.

If you are logged in as the Postgres user, you do not need the -U. Without it, Windows will try to log in to PostgreSQL using the logged in user account, which may not be the same as the PostgreSQL user.

Now that you have the data loaded in PostgreSQL, the following section will show you how you can use Python to query it.

Table of Contents for Loading rasters into PostgreSQL

Create new playlist

Sign In

Sign Up

Table of Contents for
Loading rasters into PostgreSQL