Re: \i running on windows

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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of jerome
Sent: Friday, 26 May, 2006 7:20 pm
To: pgsql-admin(at)postgresql(dot)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

!DSPAM:14,44774d5a34493449410149!