psql \i - Mailing list pgsql-general

From Richard Harvey Chapman
Subject psql \i
Date
Msg-id Pine.LNX.4.10.10007121120530.10311-100000@smile.3gfp.com
Whole thread Raw
Responses Re: psql \i --UPDATE
List pgsql-general
I have a text file of SQL commands which contains tabs.  I used to be able
to import it using psql using "\i file.sql".  Now, I've upgraded to 7.0.2
and it treats the file as if I'm entering it all in manually.  It treats
the tabs as completion commands.

CREATE TABLE alpha (
<TAB>num<TAB>SERIAL PRIMARY KEY
);

will return a syntax error at PRIMARY because it sees the following:

CREATE TABLE alpha (
numSERIAL PRIMARY KEY
);

Is there something new that I have to do?

(besides converting the tabs -- if all else fails, I'll do that)

R.



pgsql-general by date:

Previous
From: "J.R. Belding"
Date:
Subject: Re: psql and Gnu readline
Next
From: Richard Harvey Chapman
Date:
Subject: automatic sequences