Import from PostGIS¶
Use PostGIS when the data already lives in a spatial database.
You need to be signed in. Saving the connection once is the usual path.
Before you start¶
You'll need:
- Host, port, and database name
- Username and password
- SSL mode (leave prefer if you are not sure)
- A spatial table or view GeoJibe can read
The saved Source is the database connection. You choose the schema and table each time you import or save a Job.
1. Save the PostGIS Source¶
Open Sources → Add Source → PostGIS.
Fill in host, port, SSL mode, database, username, and password. Click Test, then Save.
2. Add PostGIS on the Canvas¶
Add PostGIS, choose the saved Source or enter the connection, then Connect.
Choose a schema, then a table or view. Click Import. GeoJibe copies the table into the job workspace and inspects it.
After Import, Transform sees the real field names. Convert offers the same formats as an uploaded file.
You can also fill the connection in manually for a one-off run. You do not have to save a Job.
3. Process and deliver¶
Add Transform, Convert, or Python if you need them. Then choose a Destination — Download, another PostGIS table, GeoServer, GeoNode, and the rest work as usual.
Click Run.
Saved Jobs¶
When you save as a Job, GeoJibe stores the connection plus the schema and table you selected. The next run imports that table again.