From: Richard Huxton <dev@archonet.com>
To: Bart Degryse <Bart.Degryse@indicator.be>
Cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Function description
Date: Fri, 15 Feb 2008 11:17:55 +0000
Message-ID: <47B574E3.9070401@archonet.com> (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>
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
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: dev@archonet.com, Bart.Degryse@indicator.be
Subject: Re: Function description
In-Reply-To: <47B574E3.9070401@archonet.com>
* 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