Issue with Viewing Created Table in pgAdmin

From: Reuben Fraser <rjfraser(dot)casino(at)gmail(dot)com>
To: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Issue with Viewing Created Table in pgAdmin
Date: 2024-07-05 02:58:04
Message-ID: CABfU-NRVAEQw2O7uJ9tcjGvzWY+9gy-tp2fNKg=v+eJsaPk9KA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Yogesh Mahajan 2024-07-05 03:55:37 Re: Issue with Viewing Created Table in pgAdmin
Previous Message Aditya Toshniwal 2024-07-04 12:06:06 Re: upgrade from version 4.28 to 8.8