From: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
To: Bart Degryse <Bart.Degryse@indicator.be>
Cc: Richard Huxton <dev@archonet.com>
Cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Function description
Date: Fri, 15 Feb 2008 22:46:43 +1100
Message-ID: <47B57BA3.6040508@eclinic.com.au> (raw)
In-Reply-To: <47B58012.A3DD.0030.0@indicator.be>
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>
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.auAttachments:gavinb.vcf (text/x-vcard, 525B) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gavinb@eclinic.com.au, Bart.Degryse@indicator.be, dev@archonet.com
Subject: Re: Function description
In-Reply-To: <47B57BA3.6040508@eclinic.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox