Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 547152E0096
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:05:54 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 61057-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:05:45 -0400 (AST)
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 296212E0062
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2008 07:05:50 -0400 (AST)
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Fri, 15 Feb 2008 12:05:48 +0100
Message-Id: <47B58012.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Fri, 15 Feb 2008 12:05:39 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: "Richard Huxton" <dev@archonet.com>,
	"PostgreSQL SQL List" <pgsql-sql@postgresql.org>
Subject: Re: Function description
References: <47B56063.A3DD.0030.0@indicator.be><47B556E6.8090200@archonet.co
	m><47B56F0B.A3DD.0030.0@indicator.be>
	<47B56651.9050600@archonet.com><47B5798B.A3DD.0030.0@indicator.be><47B5798B
	.A3DD.0030.0@indicator.be><47B56E6E.2010303@archonet.com>
In-Reply-To: <47B56E6E.2010303@archonet.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__PartFBDD0413.1__="
X-imss-version: 2.049
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/120
X-Sequence-Number: 30211

--=__PartFBDD0413.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

>>>> Richard Huxton <dev@archonet.com> 2008-02-15 11:50 >>>
>>> To see how e.g. \dC etc work start psql with -E
>>>
>> I'm sorry, but I don't have commandline access to the database. That =
would
>> require an amount of trust and a level of competence our ICT department =
is incapable of.
>
>Well, if you have access to prt 5432 (or whatever you are using) on =
the=20
>DB host you can run psql locally: psql -h <db-hostname>
=20
All I have is my desktop Windows pc. I work on the database using EMS SQL =
Manager for PostgreSQL.
There I can run whatever statement I want, but it's not psql.
What do you exactly mean with "run psql locally"? Should I be able to run =
some psql.exe
from my windows cmd environment. Or should I start something else first?

>As a last resort you can always see how they work on a local copy, =
then=20
>cut + paste the SQL.
Here too, I don't know what you mean exactly with "a local copy".

--=__PartFBDD0413.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>&gt;&gt;&gt;&gt; Richard Huxton &lt;dev@archonet.com&gt; 2008-02-15 =
11:50 &gt;&gt;&gt;<BR>&gt;&gt;&gt; To see how e.g. \dC etc work start psql =
with -E<BR>&gt;&gt;&gt;<BR>&gt;&gt; I'm sorry, but I don't have commandline=
 access to the database. That would<BR>&gt;&gt; require an amount of trust =
and a level of competence our ICT department is incapable of.<BR>&gt;<BR>&g=
t;Well, if you have access to prt 5432 (or whatever you are using) on the =
<BR>&gt;DB host you can run psql locally: psql -h &lt;db-hostname&gt;</DIV>=

<DIV>&nbsp;</DIV>
<DIV>All I have is my desktop Windows pc. I work on the database using EMS =
SQL Manager for PostgreSQL.</DIV>
<DIV>There I can run whatever statement I want, but it's not psql.</DIV>
<DIV>What do you exactly mean with "run psql locally"? Should I be able to =
run some psql.exe</DIV>
<DIV>from my windows cmd environment. Or should I start something else =
first?<BR><BR>&gt;As a last resort you can always see how they work on a =
local copy, then <BR>&gt;cut + paste the SQL.<BR></DIV>
<DIV>Here too, I don't know what you mean exactly with "a local copy".<BR><=
/DIV></BODY></HTML>

--=__PartFBDD0413.1__=--