pgAdmin Error when trying to run a simple SELECT
require($_SERVER['DOCUMENT_ROOT']."/includes/top_config.php");
?>
pgAdmin Error when trying to run a simple SELECT
> My problem is this:
Whenever I try to run an SQL statement like:
>
> SELECT * from refUSERS;
>
> I get an error:
>
> ERROR: Relation
"refusers" does not exist.
PostgreSQL folds unquoted
identifiers to lower case. So if your select has the correct spelling you need
to use:
SELECT * from
"refUSERS";
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
John,
Thank-you. You solved my problem!
Sincerely,
Brad Smith.
|
Home |
Main Index |
Thread Index