Thread: pgadmin doesn't show the tables in brand new created db
Hi all,
I'm new to pgsql and I'm doing homeworks...
as in the object I created a db and executed the script attached.
Although there I uploaded and executed correctly it with psadmin it wouldn't show the tables at all, while searching for them via cli I can find them all.
Any tip?
thanks in advance
Roberto
Attachment
On 2/8/22 8:48 AM, Roberto D. Maggi wrote: > Hi all, > I'm new to pgsql and I'm doing homeworks... > as in the object I created a db and executed the script attached. > Although there I uploaded and executed correctly it with psadmin it > wouldn't show the tables at all, while searching for them via cli I can > find them all. > Any tip? Permissions... in pgadmin, are you connecting to the instance with the same username as with psql? -- Angular momentum makes the world go 'round.
Roberto,
I would recommend checking your auto-commit settings. Likely, your change was not committed and only visible within pgadmin.
Best regards,
Dan Smith
On Tue, Feb 8, 2022, 10:49 Roberto D. Maggi <robertodmaggi@gmail.com> wrote:
Hi all,I'm new to pgsql and I'm doing homeworks...as in the object I created a db and executed the script attached.Although there I uploaded and executed correctly it with psadmin it wouldn't show the tables at all, while searching for them via cli I can find them all.Any tip?thanks in advanceRoberto
Hi Ron,
no the dbs have different users.
I'm checking out the other tips
I'm checking out the other tips
Il giorno mar 8 feb 2022 alle ore 18:08 Dan Smith <j.daniel.smith1@gmail.com> ha scritto:
Roberto,I would recommend checking your auto-commit settings. Likely, your change was not committed and only visible within pgadmin.Best regards,Dan SmithOn Tue, Feb 8, 2022, 10:49 Roberto D. Maggi <robertodmaggi@gmail.com> wrote:Hi all,I'm new to pgsql and I'm doing homeworks...as in the object I created a db and executed the script attached.Although there I uploaded and executed correctly it with psadmin it wouldn't show the tables at all, while searching for them via cli I can find them all.Any tip?thanks in advanceRoberto
[solved]
The problem was the difference of users.
thanks to all.
to next, not so far, issue :)
thanks to all.
to next, not so far, issue :)
Il giorno mer 9 feb 2022 alle ore 16:13 Roberto D. Maggi <robertodmaggi@gmail.com> ha scritto:
Hi Ron,no the dbs have different users.
I'm checking out the other tipsIl giorno mar 8 feb 2022 alle ore 18:08 Dan Smith <j.daniel.smith1@gmail.com> ha scritto:Roberto,I would recommend checking your auto-commit settings. Likely, your change was not committed and only visible within pgadmin.Best regards,Dan SmithOn Tue, Feb 8, 2022, 10:49 Roberto D. Maggi <robertodmaggi@gmail.com> wrote:Hi all,I'm new to pgsql and I'm doing homeworks...as in the object I created a db and executed the script attached.Although there I uploaded and executed correctly it with psadmin it wouldn't show the tables at all, while searching for them via cli I can find them all.Any tip?thanks in advanceRoberto