NGA Backend PostgreSQL

[thanhnguyen]

Hi everybody,
I have try first time NGA by PostgreSQL in V3.0
How we access the archive DB/Table by Database tool ? Naming look like not the same

[fmulder]

Install a tool like pgAdmin to directly look into your database. Note: I had to install a different version. The one that came with my PostgreSQl installation crashed. I then installed a different one, with a different version number, and this worked

The databas scheme will show you that 2 views are being created. One for events and one for alarms. These views get changed when new tables are made and old ones are dropped. It is very simple to implement an external tool that does a query on these views

You can also use the pgAdmin tool and directlrun a query. Simply do something like 'SELECT * from EVENT..' (Look in your model for the exact name of the views)

So :

* use pgAdmin to find the views
* use pgAdmin to try a SELECT query on the views
* Write down the view on a piece of paper
* Start your external tool and execute this query

Good luck

[leoknipp]

In the documentation you can find a description for the schema used in the PostgreSQL database:
https://www.winccoa.com/documentation/W ... rview.html

Best Regards
Leopold Knipp
Senior Support Specialist