I successfully executed the following SQL to create a table named Restaurants in pgAdmin:
CREATE TABLE Restaurants (
RestaurantID SERIAL PRIMARY KEY,
RestaurantName VARCHAR(255) NOT NULL,
District VARCHAR(100),
Neighborhood VARCHAR(100),
CuisineCategory VARCHAR(100),
CuisineSubcategory VARCHAR(100),
Active BOOLEAN DEFAULT true,
YearsIncluded TEXT,
Address TEXT,
Telephone VARCHAR(20),
Menu TEXT[],
Hours TEXT[],
SpecialHours TEXT[],
AdditionalInfo TEXT,
ImageURL TEXT,
PriceCategory VARCHAR(50),
TripAdvisorRating DECIMAL(3, 2),
MichelinGuideRating VARCHAR(50),
VegetarianFriendly BOOLEAN DEFAULT false,
VeganOptions BOOLEAN DEFAULT false,
HalalOptions BOOLEAN DEFAULT false,
GlutenFreeOptions BOOLEAN DEFAULT false,
Meals TEXT[],
SignatureDishes TEXT[],
OpenNow BOOLEAN DEFAULT false,
OnlineBooking BOOLEAN DEFAULT false,
Awards TEXT[],
GoodFor TEXT[],
RestaurantFeatures TEXT[]
);
The execution was confirmed successful in the Query History. However, despite following the steps provided by ChatGPT to view the table in pgAdmin, I am unable to locate it. Specifically, after navigating to the correct database (SeoulKPopAdventuresMap) and schema (public) and attempting to open "View/Edit Data" or "Browse Data," no table appears in the grid-like interface as expected.
Could you please advise on how to resolve this issue and ensure the table is correctly displayed in pgAdmin?
Sincerely,
Reuben, a new user.