Re: Use of '&' as table prefix in query

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Use of '&' as table prefix in query
Date: 2021-07-12 17:50:21
Message-ID: e67f712a-a145-38b7-f660-f7d11b78bbf7@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/12/21 10:45 AM, Rich Shepard wrote:
> On Mon, 12 Jul 2021, Tom Lane wrote:
>
>> AFAICS this is invoking a prefix operator named "&". There is no such
>> operator built into Postgres. Maybe psql's "\do+ &" would jog your memory
>> about where yours came from.
>
> tom,
>
> I thought it wasn't part of postgres. I've no idea why it's there, but I'll
> remove it and see what happens.

You should also follow Tom's suggestion and do:

\do+ &

in psql.

>
> Thanks!
>
> Rich
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2021-07-12 17:51:07 Re: Use of '&' as table prefix in query
Previous Message Adrian Klaver 2021-07-12 17:48:15 Re: Use of '&' as table prefix in query