BUG #16494: cant use row['field name']

Hi

po 15. 6. 2020 v 8:52 odesílatel PG Bug reporting form <
noreply@postgresql.org> napsal:

The following bug has been logged on the website:

Bug reference: 16494
Logged by: Preeth TYK
Email address: preetha@tyk.jp
PostgreSQL version: 12.3
Operating system: Windows
Description:

I am using pgsql with php. When trying to echo data in tables using
row['field name'] , it is returning error. I am currently using
row['row_number'] which is really inconvenient.

If it is an issue, then it is a PHP API issue. This is a PostgreSQL bug
list.

You wrote nothing about the API that you use. Probably it is an older PG
driver. a PDO driver works differently.

But I don't think so this is a bug. Building an int indexed array is faster
than building a string indexed array. This API is pretty old, and had
strong benefits on slower computers.

If you want different access, then you can you different API

https://www.php.net/manual/en/function.pg-fetch-assoc.php
https://www.php.net/manual/en/function.pg-fetch-array.php
https://www.php.net/manual/en/function.pg-fetch-object.php

Regards

Pavel Stehule