---
title: "Using PostgreSQL DB schema created with Collect for storing Collect Earth interpretations"
url: "https://openforis.support/questions/1793/using-postgresql-db-schema-created-with-collect-for-storing-collect-earth-interpretations"
tags: ["collect", "collectearth"]
status: "answered"
score: 0
answer_count: 3
asked: "2018-05-15T07:08:54"
last_activity: "2018-05-19T09:10:02"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Using PostgreSQL DB schema created with Collect for storing Collect Earth interpretations

Asked by jurafejfar on 2018-05-15

I was wondering, whether it would be possible to use DB schema “collect” created with application Collect connected to PostgreSQL, directly for storing Collect Earth interpretations? It seems that both DB schemes (created by Collect and Collect Earth) have the same structure.


## Answer (score 0, by Stefano (OF) on 2018-05-17)

Link: https://openforis.support/questions/1793/using-postgresql-db-schema-created-with-collect-for-storing-collect-earth-interpretations/1797

Hi,  
The answer is: yes. Collect and Collect Earth use the same database schema.  
Thanks,  
Open Foris Team


## Answer (score 0, by jurafejfar on 2018-05-17)

Link: https://openforis.support/questions/1793/using-postgresql-db-schema-created-with-collect-for-storing-collect-earth-interpretations/1798

Hi, 

thank you very much, [that][1] sounds great! Is this covered by any manual? I found and tested only separate functionality:

 * Collect + oneDatabase (described in [Collect manual, ANNEX 2. POSTGRESQL WITH COLLECT][2]) or 
 * CollectEarth + otherDatabase (described in [Collect Earth manual, 7.7 Setting up a PostgreSQL database][3]) 

synchronizing the survey project through .cep file. If both applications can **share the same DB**, it should be possible to:

 1. Install Collect and connect it to PostgreSQL according to the manual. This will create DB with schema collect.
 2. Develop survey project using Collect GUI. Changes in survey project will be stored in the database. **I will not export survey to .cep.**
 3. Install Collect Earth and set up connection to the existing DB? This will not create its own DB on start? **I will not import survey from .cep**.
 4. Do CE interpretation of plots, which will be saved into DB created in step 1. Is it necessary to somehow set privileges (looks like collect is handling user roles in application not using DB users)?


  [1]: http://www.openforis.org/support/questions/1793/using-postgresql-db-schema-created-with-collect-for-storing-collect-earth-interpretations/1797
  [2]: http://www.openforis.org/fileadmin/docs/collect/OF_Collect_MANUAL_20180313.pdf
  [3]: http://openforis.org/fileadmin/user_upload/Collect_Earth_Tutorials/Collect_Earth_User_Manual_20150618_highres_full.pdf


## Answer (score 0, by collectearth on 2018-05-19)

Link: https://openforis.support/questions/1793/using-postgresql-db-schema-created-with-collect-for-storing-collect-earth-interpretations/1804

I have personally not tested this approach ut it should work.

Collect Earth does not create a DB or schema, they should have been previously created.

You should import the survey in Collect Earth, otherwise it will not know "what to do"

You should not need to create any special privileges...

Let us know if it works.