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

On Mon, 12 Jul 2021, Adrian Klaver wrote:


> You should also follow Tom's suggestion and do:
> \do+ &
> in psql.

It's the bitwise 'and':
# \do+ &
                                        List of operators
    Schema   | Name | Left arg type | Right arg type | Result type |   Function   | Description 
------------+------+---------------+----------------+-------------+--------------+-------------
  pg_catalog | &    | bigint        | bigint         | bigint      | int8and      | bitwise and
  pg_catalog | &    | bit           | bit            | bit         | bitand       | bitwise and
  pg_catalog | &    | inet          | inet           | inet        | inetand      | bitwise and
  pg_catalog | &    | integer       | integer        | integer     | int4and      | bitwise and
  pg_catalog | &    | macaddr       | macaddr        | macaddr     | macaddr_and  | bitwise and
  pg_catalog | &    | macaddr8      | macaddr8       | macaddr8    | macaddr8_and | bitwise and
  pg_catalog | &    | smallint      | smallint       | smallint    | int2and      | bitwise and
(7 rows)

which doesn't seem appropriate in this context.

Thanks,

Rich