Re: Issue with Viewing Created Table in pgAdmin

Hi,

You need to select the table for which you want to see data. You have
selected table*s* node under which all tables would e listed.
[image: Screenshot 2024-07-06 at 1.50.01 PM.png]

You can use documentation from here
<https://www.pgadmin.org/docs/pgadmin4/8.9/index.html>.

Thanks,
Yogesh Mahajan
EnterpriseDB

On Sat, Jul 6, 2024 at 12:41 PM Reuben Fraser <rjfraser(dot)casino(at)gmail(dot)com>
wrote:

> Ok, I will check. That didn't help. As my screenshot below shows, when I
> click on the table in the left-hand column, it doesn't change that the
> table icon above remains grey, not black, and cannot be clicked. So, if
> this is what you mean when you say I should select the table, it proves
> that your theory about what is wrong is incorrect. Otherwise, you must mean
> that there is some other way for me to select the table, not the column
> node, and so you need to explain more clearly what you mean.
>
> [image: 2024-7-06-Screenshot-3.png]
>
> Reuben
>
> On Sat, 6 Jul 2024 at 00:20, Yogesh Mahajan <
> yogesh(dot)mahajan(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> It's because you have selected columns node not the table. Select table
>> and right click on it.
>>
>> On Fri, 5 Jul 2024, 6:42 pm Reuben Fraser, <rjfraser(dot)casino(at)gmail(dot)com>
>> wrote:
>>
>>> The table that your screenshot is pointing at is grey, not black, in my
>>> screenshot, which means that it cannot be clicked. See the cropped image
>>> below:
>>>
>>> [image: 2024-7-05-Screenshot-2.png]
>>>
>>> On Fri, 5 Jul 2024 at 19:46, Yogesh Mahajan <
>>> yogesh(dot)mahajan(at)enterprisedb(dot)com> wrote:
>>>
>>>>
>>>> Hi,
>>>>
>>>> You need to select the table and then click on the View/Edit icon
>>>> beside the query tool icon in object explorer.(or from the context menu of
>>>> table). It should open the new window showing table data in the Data Output
>>>> panel.
>>>> You can expect to screen like below.(Table does not have any data)
>>>>
>>>> [image: Screenshot 2024-07-05 at 3.15.03 PM.png]
>>>>
>>>> Kindly share a screenshot of the newly opened window if you face any
>>>> issue.
>>>>
>>>> Thanks,
>>>> Yogesh Mahajan
>>>> EnterpriseDB
>>>>
>>>>
>>>> On Fri, Jul 5, 2024 at 12:40 PM Reuben Fraser <
>>>> rjfraser(dot)casino(at)gmail(dot)com> wrote:
>>>>
>>>>> Sure!
>>>>>
>>>>> [image: 2024-7-05-Screenshot.png]
>>>>>
>>>>> On Fri, 5 Jul 2024 at 16:42, Yogesh Mahajan <
>>>>> yogesh(dot)mahajan(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> 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 <
>>>>>> rjfraser(dot)casino(at)gmail(dot)com> wrote:
>>>>>>
>>>>>>> I have already done that, as me and ChatGPT were trying to resolve
>>>>>>> this issue for about two hours and tried everything that ChatGPT could
>>>>>>> think of. For example, this is our chat when doing that:
>>>>>>>
>>>>>>> ...proceed with converting to the Query Tool tab. This will allow
>>>>>>> you to execute the SQL query I mentioned earlier to check if the table
>>>>>>> exists:
>>>>>>> SELECT * FROM information_schema.tables WHERE table_name =
>>>>>>> 'Restaurants';
>>>>>>>
>>>>>>>
>>>>>>> Click "OK" or "Yes" to confirm that you want to convert to the Query
>>>>>>> Tool tab.
>>>>>>> Paste the SQL query (SELECT * FROM information_schema.tables WHERE
>>>>>>> table_name = 'Restaurants';) into the query editor.
>>>>>>> Execute the query by clicking the play button or pressing F5.
>>>>>>> Review the output to see if the Restaurants table exists in your
>>>>>>> database.
>>>>>>> This approach will help verify if the table is indeed present in the
>>>>>>> database and potentially shed light on why it's not displaying correctly in
>>>>>>> the data view/edit mode. If the query returns information about the
>>>>>>> Restaurants table, then it exists, and you can proceed with further SQL
>>>>>>> operations as needed.
>>>>>>> The result is SeoulKPopAdventuresMap in the table_catalog,
>>>>>>> table_schema is public, table_name is Restaurants, table_type, BASE TABLE,
>>>>>>> and everything else is [null] except for is_insertable_into which is yes,
>>>>>>> and is_typed, which is no.
>>>>>>>
>>>>>>> Great! It looks like the Restaurants table exists in your database (
>>>>>>> SeoulKPopAdventuresMap) as a base table in the public schema. This
>>>>>>> confirms that the table creation was successful.
>>>>>>>
>>>>>>> To view or edit the data within the Restaurants table using
>>>>>>> pgAdmin, you might need to ensure you are navigating to the correct section:
>>>>>>>
>>>>>>> 1.
>>>>>>>
>>>>>>> *Navigate to the Table:* Ensure you are looking under the
>>>>>>> correct database (SeoulKPopAdventuresMap) and schema (public)
>>>>>>> where the table was created.
>>>>>>> 2.
>>>>>>>
>>>>>>> *View/Edit Data:* Look for an option like "View/Edit Data" or
>>>>>>> "Browse Data" in pgAdmin. This should open a grid-like interface where you
>>>>>>> can see the rows of the Restaurants table.
>>>>>>> 3.
>>>>>>>
>>>>>>> *Grid View:* If clicking on the grid icon doesn't open the data
>>>>>>> grid view directly, try to refresh the interface or restart pgAdmin to
>>>>>>> ensure everything loads correctly.
>>>>>>>
>>>>>>> If you're still having trouble finding or viewing the data, consider
>>>>>>> restarting pgAdmin or checking if there are any filters or settings
>>>>>>> preventing the table from being displayed. Sometimes, a simple refresh or
>>>>>>> reconnection to the database can resolve such issues.
>>>>>>>
>>>>>>> I have already been doing the below all along:
>>>>>>>
>>>>>>> To view or edit the data within the Restaurants table using pgAdmin,
>>>>>>> you might need to ensure you are navigating to the correct section:
>>>>>>>
>>>>>>> Navigate to the Table: Ensure you are looking under the correct
>>>>>>> database (SeoulKPopAdventuresMap) and schema (public) where the table was
>>>>>>> created.
>>>>>>>
>>>>>>> View/Edit Data: Look for an option like "View/Edit Data" or "Browse
>>>>>>> Data" in pgAdmin. This should open a grid-like interface where you can see
>>>>>>> the rows of the Restaurants table.
>>>>>>>
>>>>>>> But as I have already explained, what I am not seeing is a Grid View
>>>>>>>
>>>>>>> On Fri, 5 Jul 2024 at 13:56, Yogesh Mahajan <
>>>>>>> yogesh(dot)mahajan(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> 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.
>>>>>>>>>
>>>>>>>>