Can't create table in phpPgAdmin
I am using PostgreSQL servers in phpPgAmin and all I want to do is create one table using SQL code. This is the code I am using in its entirety.
CREATE TABLE BIDS (
BIDID NUMERIC(3) NOT NULL,
CLIENTID NUMERIC(3) NOT NULL,
BIDDINGDATE DATE,
DESCRIPTION TEXT,
PRICE NUMERIC(4,2),
HOURLYRATE BOOLEAN,
APPROVED BOOLEAN NOT NULL,
COMMENTS TEXT
CONSTRAINT BIDS_PRIMARY_KEY PRIMARY KEY (BIDID));
This code should create a table, add some attributes and create a primary key. However, when executing SQL, it throws this error.
I don't know why this error occurs as there is no SELECT statement in my code. Is this a common occurrence with phpPgAdmin or PostgreSQL? If so, what should I do to create the table correctly? Keep in mind that I need to do this with SQL code.
source to share
The phpPgAdmin UI provides two links to launch SQL - one in the main body of the page and one in the menu bar at the top of the page.
The main body of the page displays the error that you see if you run a data definition statement such as CREATE TABLE.
However, the data definition queries will run on the menu bar without issue.
In short:
source to share