Loading raster and vector layers into PostGIS using FEXPORT

To load vector and raster layers into a PostGIS database built on PostgreSQL, you must configure the FEXPORT parameters in a specific way. The following table describes this configuration.

Parameter	Description
FILI	Specify the name of the file containing the layer(s) to be loaded.
FILO	For raster layers, specify the connection information and the table name that will be used when the image channel or channels are loaded into the database as a record of the pci_raster table. The format of this string should be: `PG://username:password@server:portnumber/pci_raster?d=databasename&w=layer_name=rastername` For vector layers, specify the connection information and table name that will be used when the vector layer is loaded into the database as a table. The format of this string should be: `PG://username:password@server:portnumber/tablename?d=databasename&s=geometryfieldname` Note: PG stands for PostgreSQL. This is required to indicate the database schema. If there is a default port number, this part of the string can be ignored. For rasters, if you do not enter a a pci_raster table name, it will be added automatically. For vectors, if you do not enter a geometry field name, "geometry" will be used by default. For rasters, the string can be simplified as follows: `PG://username:password@server/?d=databasename` For vectors, the string can be simplified as follows: `PG://username:password@server/tablename?d=databasename`
DBIW	Leave blank. The entire layer will be processed by default.
DBIC	For rasters, specify the channel number(s). Leave blank for vector layers (not applicable).
DBIB	Not applicable. Leave blank.
DBVS	For vector layers, specify the layer number. Leave blank for raster layers (not applicable).
DBLUT	Not applicable. Leave blank.
DBPCT	Not applicable. Leave blank.
FTYPE	Use "PG" for the PostGIS format.
FOPTIONS	Not applicable. Leave blank.

Examples

The following EASI example demonstrates how to configure FEXPORT to load raster layers into PostGIS.

EASI>FILI=”C:\v103\demo\irvine.pix”                          
EASI>FILO=”PG://user:pass@myserver:5286/pci_raster?d=mydatabasename”                                    
EASI>DBIW=                                                                                                                 
EASI>DBIC=2                                                                                                                  
EASI>DBIB=                                                                                                                     
EASI>DBVS=                                                                                                             
EASI>DBLUT=                                                                                                       
EASI>DBPCT=                                                                                             
EASI>FTYPE=”PG”                                                                                            
EASI>FOPTIONS=   
EASI>r FEXPORT

The following Python example demonstrates how to configure FEXPORT to load raster layers into PostGIS.

fili	=	”C:\v103\demo\irvine.pix”  
filo	=	”PG://user:pass@myserver:5286/pci_raster?d=mydatabasename”
dbiw	=	[]
dbic	=	[2]
dbib	=	[]
dbvs	=	[]
dblut	=	[]
dbpct	=	[]
ftype	=	"PG"
foptions	=	""

fexport( fili, filo, dbiw, dbic, dbib, dbvs, \\
    dblut, dbpct, ftype, foptions )

The following EASI example demonstrates how to configure FEXPORT to load vector layers into PostGIS:

EASI>FILI=”C:\v103\demo\irvine.pix”                          
EASI>FILO=”PG://user:pass@myserver:5286/mytablename?d=mydatabase”                   
EASI>DBIW=                                                                                                                 
EASI>DBIC=                                                                                                                  
EASI>DBIB=                                                                                                                     
EASI>DBVS=25                                                                                                                
EASI>DBLUT=                                                                                                       
EASI>DBPCT=                                                                                             
EASI>FTYPE=”PG”                                                                                            
EASI>FOPTIONS=   
EASI>r FEXPORT

The following Python example demonstrates how to configure FEXPORT to load vector layers into PostGIS:

fili	=	”C:\v103\demo\irvine.pix”  
filo	=	”PG://user:pass@myserver:5286/mytablename?d=mydatabase”
dbiw	=	[]
dbic	=	[]
dbib	=	[]
dbvs	=	[25]
dblut	=	[]
dbpct	=	[]
ftype	=	"PG"
foptions	=	""

fexport( fili, filo, dbiw, dbic, dbib, dbvs, \\
    dblut, dbpct, ftype, foptions )