Re: determine client os

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: determine client os
Date: 2011-06-14 07:52:04
Message-ID: 20110614075204.GA2617@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 14, 2011 at 09:35:52AM +0300, Sim Zacks wrote:

> >Sim Zacks<sim(at)compulab(dot)co(dot)il> writes:
> >>All the suggestions given are for the server OS :-(
> >>My purpose is to be able to return a correct file path to the client
> >>without it specifying the OS.
> >File path? Seems to me that even if you knew the client OS, that'd
> >provide next to no information about the installation pathnames of the
> >client software. Maybe you need to be a bit clearer about what you're
> >trying to accomplish.
> >
> > regards, tom lane
> It is much simpler then that. My data includes file references.
> One table has the filename with a path placeholder and another table
> contains the windows and linux versions of the full path. This is for
> an intranet and we _always_ have the same drive letters (windows) and
> mount paths (linux) for every client. When the client requests data
> that includes a file reference, I want to send the relevant path.

Send both and have the client select the one it needs.

If you don't want to need to know on the client side just
try both. One will work. If both don't there's a problem
somewhere.

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-06-14 08:01:09 Re: how to install plpython?
Previous Message Thom Brown 2011-06-14 07:49:20 Re: No implicit index created when adding primary key with ALTER TABLE