Re: Issue with Viewing Created Table in pgAdmin

2024-07-09 Thread Yogesh Mahajan
Hi, On call, we were able to locate 'restaurants' table with expected columns and there was no issue with pgadmin. If you don't use double quotation marks, then PostgreSQL creates objects with lowercase names, hence the query has created table named 'restaurants '. However there was one more table

Re: Issue with Viewing Created Table in pgAdmin

2024-07-09 Thread Yogesh Mahajan
Kindly share the details for the same. As I said earlier, I can guess the problem only from your screenshots you have shared which I have done(Did not presume anything). Thanks, Yogesh Mahajan EnterpriseDB

Re: Issue with Viewing Created Table in pgAdmin

2024-07-08 Thread Yogesh Mahajan
Hi, You need to write a query and click on the 'Execute query' button to get output. Please refer to pgadmin documentation from here . You can also refer to youtube videos which cover most of the modules of pgadmin from here

Re: Issue with Viewing Created Table in pgAdmin

2024-07-04 Thread Yogesh Mahajan
Hi, Can you please share the screenshot for pgadmin where the grid is not displayed? Thanks, Yogesh Mahajan EnterpriseDB On Fri, Jul 5, 2024 at 11:44 AM Reuben Fraser wrote: > I have already done that, as me and ChatGPT were trying to resolve this > issue for about two hours and tried everyth

Re: Issue with Viewing Created Table in pgAdmin

2024-07-04 Thread Yogesh Mahajan
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

Issue with Viewing Created Table in pgAdmin

2024-07-04 Thread Reuben Fraser
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), Cuisin