On Wed, Mar 11, 2009 at 12:07 AM, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> Hi Scott,
>
> Many thanks for your reply.
> I just tried:
> select extract (epoch from timestamp with time zone '2008-04-04
> 20:00:0.0');
> and got:
> 1207364400
> which is great!
>
> I suppose there is no problem running this query
> via PGexec() in a C program? Something like:
> result = PGexec (conn, "FETCH ALL from somePort");
It's definitely accessable by anything connecting to the db. Not sure
how that's done in C so someone else will have to chip in on that.