Re: bug in psql

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bug in psql
Date: 2002-03-10 00:33:13
Message-ID: slrna8la99.67.missive@whave.frontiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> This seems strange:
>
> nconway=> create table ddd\\bar;
> Invalid command \. Try \? for help.
> nconway-> select 1;

Notice ..^ secondary prompt here
Try \e between these two commands to see the
current query buffer.

> ERROR: parser: parse error at or near "select"
>

Because your query is actually:
CREATE TABLE ddd SELECT 1;

Try this:

CREATE TABLE ddd \d
(i int)
\e

OR

CREATE TABLE ddd\\bar;
\e

Or, are you saying you want to be able to create a table
with a backslash in the name by escaping the backslash?

If so, you can use:

CREATE TABLE "ddd\bar" (i int);

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masaru Sugawara 2002-03-10 05:43:14 Re: Adding qualification conditions to EXPLAIN output
Previous Message Thomas Lockhart 2002-03-10 00:28:51 Re: [PATCHES] Small fix for _equalValue()