Re: Issue with Viewing Created Table in pgAdmin
| От | Yogesh Mahajan |
|---|---|
| Тема | Re: Issue with Viewing Created Table in pgAdmin |
| Дата | |
| Msg-id | CAMa=N=NMrpc26AQ8u6fscT+HawXmu0XC=Sm5eKbjJ96x+ZoaEw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Issue with Viewing Created Table in pgAdmin (Reuben Fraser <rjfraser.casino@gmail.com>) |
| Список | pgadmin-support |
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.casino@gmail.com> wrote:
On Tue, 9 Jul 2024 at 20:37, Reuben Fraser <rjfraser.casino@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,
ReubenOn Tue, 9 Jul 2024 at 19:59, Yogesh Mahajan <yogesh.mahajan@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 MahajanEnterpriseDB
В списке pgadmin-support по дате отправления: