jdavis wrote:
> Hello,
> I created 25 postgres databases by hand. Each with one small table.
> All the databases are named like so...
>
> MY_DATA_0
> MT_DATA_1 etc..
>
> When i use this code
>
> use Pg;
> $conn = Pg::connectdb("dbname=MY_DATA_0");
> if ($conn->status != PGRES_CONNECTION_OK){
Hi,
In Postgres, all non-quoted identifiers are converted to lower-case, unless they
are quoted.
e.g. SELECT * FROM MY_DATA_0;
Error: my_date_0 does not exist
try SELECT * FROM "MY_DATA_0";
or probably better, in future, use lowercase names, e.g. SELECT * FROM my_data_0;
Rich.
-Origin
