Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 8ABAE2E005F
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:18:03 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 69844-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 15 Feb 2008 07:17:58 -0400 (AST)
Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134])
	by postgresql.org (Postfix) with ESMTP id 9BE8C2E0056
	for <pgsql-sql@postgresql.org>; Fri, 15 Feb 2008 07:17:58 -0400 (AST)
Received: from [84.51.143.99] (helo=server3.office.archonet.com)
	by pih-relay08.plus.net with esmtp (Exim) id 1JPyZo-0003yJ-2V;
	Fri, 15 Feb 2008 11:17:56 +0000
Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36])
	by server3.office.archonet.com (Postfix) with ESMTP id E171027405F;
	Fri, 15 Feb 2008 11:17:55 +0000 (GMT)
Message-ID: <47B574E3.9070401@archonet.com>
Date: Fri, 15 Feb 2008 11:17:55 +0000
From: Richard Huxton <dev@archonet.com>
User-Agent: Thunderbird 2.0.0.9 (X11/20071031)
MIME-Version: 1.0
To: Bart Degryse <Bart.Degryse@indicator.be>
CC: 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: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Plusnet-Relay: 3d1ae9d75fcc43e00f7b2a9124ce8f2a
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/121
X-Sequence-Number: 30212

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?

Well, the windows installer comes with the backend database server, 
psql.exe, pgadmin, manuals etc. - I don't know if you can just install 
psql. From psql you can access local or remote databases. Same for the 
pg_dump/restore command-line tools. Unless EMS is accessing the server 
via ODBC or similar it should just work.

>> 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".

Install PostgreSQL locally, copy the schema from your main server and 
add some test data.

-- 
   Richard Huxton
   Archonet Ltd