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 'Restaurants'(initial letter caps) which I guess might have been created using pgadmin and did not have any columns which leads to confusion. Note - If you specify table name with capital letter, then pgadmin uses double quotation marks, hence table created with same case as provided in 'Create table' dialogue.
Thanks, Yogesh Mahajan EnterpriseDB On Tue, Jul 9, 2024 at 4:09 PM Reuben Fraser <rjfraser.cas...@gmail.com> wrote: > Join Zoom Meeting > https://us04web.zoom.us/j/79673373389?pwd=3HsVsfraBgq3YkG9mYnkTNQJQw9wBk.1 > > On Tue, 9 Jul 2024 at 20:37, Reuben Fraser <rjfraser.cas...@gmail.com> > wrote: > >> Hi Yogesh, >> >> I've scheduled our Zoom meeting for this evening 30 minutes from now at >> 9:00 PM, AEST; UTC+10:00. Could you please confirm if this time works for >> you, and let me know if you'll be able to attend? >> >> Looking forward to our discussion. >> >> Best regards, >> >> Reuben >> >> On Tue, 9 Jul 2024 at 19:59, Yogesh Mahajan < >> yogesh.maha...@enterprisedb.com> wrote: >> >>> 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 >>> >>> >>>
