Re: Issue with Viewing Created Table in pgAdmin

From: Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com>
To: Reuben Fraser <rjfraser(dot)casino(at)gmail(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Issue with Viewing Created Table in pgAdmin
Date: 2024-07-05 03:55:37
Message-ID: CAMa=N=My2qf6zOVf1QZU1A=beTLCccpfDAJG1pZ3puagzfKE8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

Are you able to locate the same table in object explorer? View/Edit data
will appear in the context menu on the table.
Alternatively , you can open a query for the same table in the query tool
to cross check if it is present. If it's present then, select the same
database and click on 'Search Object' icon beside the filter icon in object
explorer at top. Enter table name and click on search result. It will take
you to the object location in the object explorer.

Thanks,
Yogesh Mahajan
EnterpriseDB

On Fri, Jul 5, 2024 at 8:28 AM Reuben Fraser <rjfraser(dot)casino(at)gmail(dot)com>
wrote:

> 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.
>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Yogesh Mahajan 2024-07-05 06:42:03 Re: Issue with Viewing Created Table in pgAdmin
Previous Message Reuben Fraser 2024-07-05 02:58:04 Issue with Viewing Created Table in pgAdmin