我正在嘗試使用 PHP 在 Postgres 數據庫上執行查詢。我收到以下錯誤:pg_prepare(): Query failed: ERROR: relation "login" does not exist LINE 1: SELECT * FROM login 這是我的代碼片段:$connString = "host= port= dbname= user=password=";$conn = pg_connect($connString);if ($conn) { $sql = 'SELECT * FROM login '; if (pg_prepare($conn, "myQuery", $sql)) { $result = pg_execute($conn, "myQuery", array()); if ($result) { while ($row = pg_fetch_row($result)) { echo $row[0]; echo $row[1]; } } else { echo 'executing error!'; } } else { echo 'preparing error!'; }} else { echo "Connection error!";}if ($conn) { pg_close($conn);}當我運行此腳本時,它還會打印“準備錯誤!”我想數據庫中發生了一些事情。我試圖創建一個新表。我還嘗試在多個地方的查詢中使用引號,但沒有任何效果。這是我用來創建數據庫的查詢:CREATE TABLE login( user_id integer NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 START 1 MINVALUE 1 MAXVALUE 2147483647 CACHE 1 ), username character varying(50) COLLATE pg_catalog."default", pwd character varying(50) COLLATE pg_catalog."default", CONSTRAINT pk_user_id PRIMARY KEY (user_id))我該如何解決?
添加回答
舉報
0/150
提交
取消