From: Andy Shellam <andy@andycc.net>
To: jerome <romje@javaxpert.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: \i running on windows
Date: Sat, 27 May 2006 12:08:20 +0100
Message-ID: <44783324.4050508@andycc.net> (raw)
In-Reply-To: <4478072F.3090407@javaxpert.com>
References: <447746EB.4090509@javaxpert.com>
<001801c680f8$4a77d590$df6780b0$@net>
<4478072F.3090407@javaxpert.com>
Have you tried running your script in PgAdmin (or similar GUI)? e.g.
copy and paste your script into a new query?
jerome wrote:
> Andy Shellam a écrit :
>
>
>> Where are you trying to run your scripts, in PgAdmin, or from the psql
>> client? In psql you should specify the full path to your script, ie. \i
>> C:\The folder\the script.sql
>>
>> In PgAdmin, the easiest way is to start a new query, then copy and paste
>> your script in (or there may be an "open script" option to read it from
>> file) - I haven't used PgAdmin, I use SQL Manager's PostgreSQL Manager Lite
>> - it's much more intuitive.
>>
>> Andy
>>
>> -----Original Message-----
>> From: pgsql-admin-owner@postgresql.org
>> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of jerome
>> Sent: Friday, 26 May, 2006 7:20 pm
>> To: pgsql-admin@postgresql.org
>> Subject: [ADMIN] \i running on windows
>>
>> Hi all,
>> I'd like to use for the first time postgres on windows, used the installer
>> no problem (good stuff) i saw pgadmin (good gui) but when trying to use the
>> \i I can't figure a way to find my script to be imported...
>> What is the correct PATH to be used ? Where should I put my files in order
>> to Postgres top find them ? It 's very annoying...
>> I tried several notations (windows or Unix ones), I tried absolute &
>> relative paths ? I set up some env vars (PG_HOME & PG_DATA) soi I tried to
>> put scripts on the PG_HOME directory but it doesn't work..
>> Any idea ?
>>
>> Cheers
>> jerome
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 9: In versions below 8.0, the planner will ignore your desire to
>> choose an index scan if your joining column's datatypes do not
>> match
>>
>>
>>
>>
>>
>>
>>
>>
> thanks for your answer andy...
> but it doesn't help me much , be cause eveen using simple paths like
> c:\myscript.sql fail with a fristrating error permission...I can't guess
> how to change permissions to enable reading (files saved under my
> windows profile & read from the postgres user)..
>
> thanks
> jerome
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
> !DSPAM:14,4478078334491417513125!
>
>
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: andy@andycc.net, romje@javaxpert.com
Subject: Re: \i running on windows
In-Reply-To: <44783324.4050508@andycc.net>
References: <447746EB.4090509@javaxpert.com> <001801c680f8$4a77d590$df6780b0$@net> <4478072F.3090407@javaxpert.com> <44783324.4050508@andycc.net>
* 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