Database loogging with TS : postgresql

[CyGa]

Hello,

Currently thinking of using native database logging capability of TS, I was wondering if somebody already tried it with PostgreSQL ?

If so, can I directly use one of default schema listed in the Database options ? Otherwise, would somebody share its schema withe the community ?

Thanks for your replies !

[Brice.inno]

Hello,

Thank you for posting on National Instruments' forum.

I send you information about PostgreSQL. I hope it will help you.

http://www.postgresql.org/docs/8.1/static/app-psql.html

http://labview.ni.com/docs/proposals/2010/DSC/LoggingTo3rdPartyRDB/index.html

[CyGa]

Thank you Brice.

The first link is good... for somebody who didn't know Postgres at all before.

The second link is broken... and for what I see, it concerns DSC database logging... 

I was wondering about how to build/reuse a schema in the TS database logging option...

[Brice.inno]

Ok,

So, You want to know how to build a schema in TS database option. If I understood your problem.

I found a link on the designing of shema in the TS database option.

http://zone.ni.com/devzone/cda/tut/p/id/6484#toc7

If it is not the answer. I can still help you.

[Jose_O.]

Did you make any progress with this? I am interested on it

[CyGa]

Hi Jose,

This post is a bit old, so yes I made some progress with it !

Basically I reused MySQL schema, and made some little modifications to fit PostGres requirements on some sql resquests. Then it works pretty well !

[Jose_O.]

Good to know. I am on my baby steps with that but I'll contact you when I get there. Do you mind if we talk one of this days?

[CyGa]

As long as I can answer, I don't mind !