PostgreSQL - find device history

Posted on
Sat Dec 08, 2018 3:04 pm
Colly offline
Posts: 535
Joined: Jan 16, 2016
Location: Ireland

PostgreSQL - find device history

Hi All,

I switched to PostgreSQL some time back and in truth don't ever go near it. I have a need to find a particular device history for a period of about 6 hrs back in August. Just to add some background to the request, the local police decided to inform me today that they arrested a drunk driver on my property back then and NOW want me to give them written permission for being on my property. Strange, very strange. I still haven't invested in cameras, which will be rectified very soon. However I have a beam sensor on my driveway entrance, I now want to query that device for a set period. I have next to no knowledge of SQL but would love some help.

TIA - Colly

Posted on
Sat Dec 08, 2018 3:22 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

PostgreSQL - find device history

You can use indigo utilities to query the dB

You have to know the name of the device rest should be self explaining.



Sent from my iPhone using Tapatalk

Posted on
Sat Dec 08, 2018 3:38 pm
siclark offline
Posts: 1960
Joined: Jun 13, 2017
Location: UK

Re: PostgreSQL - find device history

I use pgAdmin4 to query it. Simple to pull the whole table and dump to excel, or restrict the SQL to the date range you want.


Sent from my iPhone using Tapatalk

Posted on
Sat Dec 08, 2018 4:47 pm
Colly offline
Posts: 535
Joined: Jan 16, 2016
Location: Ireland

Re: PostgreSQL - find device history

Thanks to both of you for your replies.

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests