This posgres aveditor database stores all the vehicles recorded by the ANPR engine. The database is necessary for the pro version but not for the free version.
Open psql
psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results.
Open a cmd prompt.
![](https://www.lpreditor.com/wp-content/uploads/2022/10/650x288xWindows_07.jpg)
Change directory to Appdata/lpreditor/aveditor :
![](https://www.lpreditor.com/wp-content/uploads/2022/10/image-1.png)
To run psql, you need to use a login (by default you can use “postgres”). You will be asked for a password (type the one chosen when you installed Postgresql).
Then hit :
psql -U postgres
![](https://www.lpreditor.com/wp-content/uploads/2022/10/image-2.png)
Run the aveditor_create.sql script
\i aveditor_create.sql
![](https://www.lpreditor.com/wp-content/uploads/2022/10/image-3.png)
![](https://www.lpreditor.com/wp-content/uploads/2022/10/image-4.png)
Check the aveditor database
Check that the aveditor database is created on postgresql server.
Open the application pgAdmin4. Normally, it has been installed with postgreSQL.
![](https://www.lpreditor.com/wp-content/uploads/2022/10/image-5.png)
You can see the aveditor database with its tables created.