Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id ADEFE2E0052
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:47:28 -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 72222-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:47:18 -0400 (AST)
Received: from panda.hostingbay.net (panda.hostingbay.net [74.86.150.75])
	by postgresql.org (Postfix) with ESMTP id 4FC392E00D9
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2008 07:47:23 -0400 (AST)
Received: from cpe-121-223-230-214.static.vic.bigpond.net.au
	([121.223.230.214] helo=[192.168.1.199])
	by panda.hostingbay.net with esmtpa (Exim 4.68)
	(envelope-from <gavinb@eclinic.com.au>)
	id 1JPz2C-0007Bh-Rw; Fri, 15 Feb 2008 22:47:17 +1100
Message-ID: <47B57BA3.6040508@eclinic.com.au>
Date: Fri, 15 Feb 2008 22:46:43 +1100
From: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
Organization: PalCare Pty Ltd
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
To: Bart Degryse <Bart.Degryse@indicator.be>
CC: 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>
	<47B58012.A3DD.0030.0@indicator.be>
In-Reply-To: <47B58012.A3DD.0030.0@indicator.be>
Content-Type: multipart/mixed; boundary="------------040805020905070400060603"
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - panda.hostingbay.net
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - eclinic.com.au
X-Source: 
X-Source-Args: 
X-Source-Dir: 
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/123
X-Sequence-Number: 30214

This is a multi-part message in MIME format.
--------------040805020905070400060603
Content-Type: multipart/alternative;
	boundary="------------050403020308070606050702"


--------------050403020308070606050702
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi Bart,

Bart Degryse wrote:
> >>>> 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
> >DB host you can run psql locally: psql -h <db-hostname>
>  
> 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?
>
The windows installer, available at;
http://www.postgresql.org/ftp/win32/

Allows you to install the DB and / OR the tools including psql
So you can just install the psql command line tool onto your local machine.

Also,
Could you ask for a restricted account on the box that runs the DB?
Ie an account that only has access to the DB tools and DB you require to 
use?

I use ssh with a limited account to access a postgesql DB running on debian.
My account on the server only allows me access to my "home" directory 
(think your own documents and settings folder - if you're a windows only 
user...) on the server and the DB's that I have a requirement to use.
> >As a last resort you can always see how they work on a local copy, then
> >cut + paste the SQL.
> Here too, I don't know what you mean exactly with "a local copy".
Download the the whole PostreSQL package;
http://www.postgresql.org/ftp/win32/

The following link however is a good place to start it contains some 
really good information and the same link above to download the windows 
version of PostgreSQL.
http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html

Then run an instance of PostgreSQL on your desktop PC.
That way you have "local" access to the DB and all of it's tools too.
You can "play around" with it to your hearts content, run SQL 
"scenarios" / test functions etc on your own copy of the DB.

Then when you're happy - perform the "locally tested" SQL upon your 
production DB via your admin tool of choice.

Hope this helps.

-- 
If I can ever be of any further assistance, please contact me.

Gavin 'Beau' Baumanis

PalCare Pty Ltd

657 Nicholson Street
Carlton North
Victoria 3054
Australia

P: +61 3 9381 4567
F: +61 3 9381 4657

M: +61 438 545 586
E: beau@palcare.com.au

W: http://www.palcare.com.au


--------------050403020308070606050702
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Bart,<br>
<br>
Bart Degryse wrote:
<blockquote cite="mid:47B58012.A3DD.0030.0@indicator.be" type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta content="MSHTML 6.00.2800.1264" name="GENERATOR">
  <div>&gt;&gt;&gt;&gt; Richard Huxton <a class="moz-txt-link-rfc2396E" href="mailto:dev@archonet.com">&lt;dev@archonet.com&gt;</a>
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>
&gt;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>
  </div>
</blockquote>
The windows installer, available at;<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/ftp/win32/">http://www.postgresql.org/ftp/win32/</a><br>
<br>
Allows you to install the DB and / OR the tools including psql<br>
So you can just install the psql command line tool onto your local
machine.<br>
<br>
Also, <br>
Could you ask for a restricted account on the box that runs the DB?<br>
Ie an account that only has access to the DB tools and DB you require
to use?<br>
<br>
I use ssh with a limited account to access a postgesql DB running on
debian.<br>
My account on the server only allows me access to my "home" directory
(think your own documents and settings folder - if you're a windows
only user...) on the server and the DB's that I have a requirement to
use.<br>
<blockquote cite="mid:47B58012.A3DD.0030.0@indicator.be" type="cite">
  <div>&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>
</blockquote>
Download the the whole PostreSQL package;<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/ftp/win32/">http://www.postgresql.org/ftp/win32/</a><br>
<br>
The following link however is a good place to start it contains some
really good information and the same link above to download the windows
version of PostgreSQL.<br>
<a class="moz-txt-link-freetext" href="http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html">http://pginstaller.projects.postgresql.org/faq/FAQ_windows.html</a><br>
<br>
Then run an instance of PostgreSQL on your desktop PC.<br>
That way you have "local" access to the DB and all of it's tools too.<br>
You can "play around" with it to your hearts content, run SQL
"scenarios" / test functions etc on your own copy of the DB.<br>
<br>
Then when you're happy - perform the "locally tested" SQL upon your
production DB via your admin tool of choice.<br>
<br>
Hope this helps.<br>
<br>
<pre class="moz-signature" cols="72">-- 
If I can ever be of any further assistance, please contact me.

Gavin 'Beau' Baumanis

PalCare Pty Ltd

657 Nicholson Street
Carlton North
Victoria 3054
Australia

P: +61 3 9381 4567
F: +61 3 9381 4657

M: +61 438 545 586
E: <a class="moz-txt-link-abbreviated" href="mailto:beau@palcare.com.au">beau@palcare.com.au</a>

W: <a class="moz-txt-link-freetext" href="http://www.palcare.com.au">http://www.palcare.com.au</a>
</pre>
</body>
</html>

--------------050403020308070606050702--

--------------040805020905070400060603
Content-Type: text/x-vcard; charset=utf-8;
 name="gavinb.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="gavinb.vcf"

begin:vcard
fn:Gavin 'Beau' Baumanis
n:Baumanis;Gavin 'Beau'
org:PalCare Pty. Ltd
adr:;;657 Nicholson Street;Carlton North;;3054;Australia
email;internet:beau@palcare.com.au
title:Senior Application Developer
tel;work:+61 -3 9381 4567
tel;cell:+61 -438 545 586
note;quoted-printable:Certified Novell Engineer (CNE)=0D=0A=
	Certified Microsoft Engineer (MCSE)=0D=0A=
	Post Graduate Certificate( IT Systems)=0D=0A=
	Trade Qualified: Electronics Technician
x-mozilla-html:TRUE
url:http://www.palcare.com.au
version:2.1
end:vcard


--------------040805020905070400060603--