how to read do the psq \i command

[Alonso García]

Hi list:
Recently I installed postgresql 8.0, marvellous; and
I've been studying the tutorial. I got stuck in
chapter 2 "The SQL languaje". There, it says that in
order to read sql commands stored in a file you can
type:
mydb=> \i basics.sql

So I create a file named CreateTable_weather.sql but
it didn't work, shows a message:
"CreateTable_weather.sql:No such file or directory".
I change the working directory and put there the sql
archive but neither worked.

Help, please...


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
[url]http://mail.yahoo.com[/url]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email]majordomo@postgresql.org[/email]

[Steve Wampler]

Alonso García wrote:

> Hi list:
> Recently I installed postgresql 8.0, marvellous; and
> I've been studying the tutorial. I got stuck in
> chapter 2 "The SQL languaje". There, it says that in
> order to read sql commands stored in a file you can
> type:
> mydb=> \i basics.sql
>
> So I create a file named CreateTable_weather.sql but
> it didn't work, shows a message:
> "CreateTable_weather.sql:No such file or directory".
> I change the working directory and put there the sql
> archive but neither worked.

This works fine with 7.4.2 under Linux:

weaver% cat >tmp.sql
select count(*) from addressbook;
weaver% psql
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

swampler=# \i tmp.sql
count
-------
148
(1 row)

swampler=# \q

Have you tried a simple test (like the above)? I haven't upgraded to
8.0 yet because of some dependencies I have with patches on JDBC in
7.4.2, but I wouldn't have expected this to break...

--
Steve Wampler -- [email]swampler@noao.edu[/email]
The gods that smiled on your birth are now laughing out loud.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [email]majordomo@postgresql.org[/email]

[Unregistered]

type \i
then single quote
the full path of the file
then closing single quote.
For example
\i 'C:\temp.sql'