From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | chenhj <chjischj(at)163(dot)com> |
Cc: | "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: psql treat backslash which is not the first character in the input line as meta-command |
Date: | 2014-10-29 09:25:23 |
Message-ID: | CAFj8pRCJrM9etq02eGfx=xJrwnBZbW5shtY8jRGGmEAKw=KQ4A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
It is not bug. Upi can you a backslash commands for entering query
postgres=# select 10 \g ~foo
postgres=# \! cat foo
?column?
----------
10
(1 row)
postgres=# select 10 as xx \gset
postgres=# \echo :xx
10
regards
Pavel Stehule
2014-10-29 10:09 GMT+01:00 chenhj <chjischj(at)163(dot)com>:
> Hi,all
>
> psql treat backslash which is not the first character in the input line
> as meta-command,and failed to execute the next query.
> It seems to be a bug.
>
> Sample1:
> postgres=# select \1 set c2=c1%3 ;
> Invalid command \1. Try \? for help.
> postgres-# select 1;
> ERROR: syntax error at or near "select"
> LINE 2: select 1;
> ^
>
>
> Sample2:
> postgres=# a \l
> List of databases
> Name | Owner | Encoding | Collate | Ctype | Access
> privileges
>
> -----------+--------+-----------+------------+------------+-------------------
> postgres | chenhj | SQL_ASCII | C | C |
> template0 | chenhj | SQL_ASCII | C | C | =c/chenhj
> +
> | | | | |
> chenhj=CTc/chenhj
> template1 | chenhj | SQL_ASCII | C | C | =c/chenhj
> +
> | | | | |
> chenhj=CTc/chenhj
> (6 rows)
>
> postgres-# select 1;
> ERROR: syntax error at or near "a"
> LINE 1: a
> ^
>
> Regards,
> Chen Huajun
>
From | Date | Subject | |
---|---|---|---|
Next Message | djlu126 | 2014-10-29 09:27:27 | BUG #11821: The delete rule problem |
Previous Message | chenhj | 2014-10-29 09:09:01 | psql treat backslash which is not the first character in the input line as meta-command |