From: | Steve Wampler <swampler(at)noao(dot)edu> |
---|---|
To: | "Alonso \"García\"" <alonsodoc_2000(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to read do the psq \i command |
Date: | 2005-01-27 21:37:12 |
Message-ID: | 41F95F08.6080302@noao.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 -- swampler(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2005-01-27 21:47:09 | Re: change encoding ? |
Previous Message | Martijn van Oosterhout | 2005-01-27 21:33:37 | Re: [BUGS] My postmaster just crashed ! |