pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgadmin doesn't show the tables in brand new created db
5+ messages / 3 participants
[nested] [flat]
* pgadmin doesn't show the tables in brand new created db
@ 2022-02-08 14:48 Roberto D. Maggi <robertodmaggi@gmail.com>
0 siblings, 2 replies; 5+ messages in thread
From: Roberto D. Maggi @ 2022-02-08 14:48 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
Attachments:
northwind_OK_.sql (application/sql, 341.5K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin doesn't show the tables in brand new created db
@ 2022-02-08 15:21 Ron <ronljohnsonjr@gmail.com>
parent: Roberto D. Maggi <robertodmaggi@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Ron @ 2022-02-08 15:21 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin doesn't show the tables in brand new created db
@ 2022-02-08 17:08 Dan Smith <j.daniel.smith1@gmail.com>
parent: Roberto D. Maggi <robertodmaggi@gmail.com>
1 sibling, 1 reply; 5+ messages in thread
From: Dan Smith @ 2022-02-08 17:08 UTC (permalink / raw)
To: Roberto D. Maggi <robertodmaggi@gmail.com>; pgsql-admin <pgsql-admin@lists.postgresql.org>
Roberto,
I would recommend checking your auto-commit settings. Likely, your change
was not committed and only visible within pgadmin.
Reference:
https://www.pgadmin.org/docs/pgadmin4/development/preferences.html#the-query-tool-node
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 advance
> Roberto
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin doesn't show the tables in brand new created db
@ 2022-02-09 15:13 Roberto D. Maggi <robertodmaggi@gmail.com>
parent: Dan Smith <j.daniel.smith1@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Roberto D. Maggi @ 2022-02-09 15:13 UTC (permalink / raw)
To: Dan Smith <j.daniel.smith1@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Ron,
no the dbs have different users.
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.
>
> Reference:
> https://www.pgadmin.org/docs/pgadmin4/development/preferences.html#the-query-tool-node
>
>
> 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 advance
>> Roberto
>>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pgadmin doesn't show the tables in brand new created db
@ 2022-02-09 15:17 Roberto D. Maggi <robertodmaggi@gmail.com>
parent: Roberto D. Maggi <robertodmaggi@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Roberto D. Maggi @ 2022-02-09 15:17 UTC (permalink / raw)
To: Dan Smith <j.daniel.smith1@gmail.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
[solved]
The problem was the difference of users.
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 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.
>>
>> Reference:
>> https://www.pgadmin.org/docs/pgadmin4/development/preferences.html#the-query-tool-node
>>
>>
>> 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 advance
>>> Roberto
>>>
>>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2022-02-09 15:17 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-02-08 14:48 pgadmin doesn't show the tables in brand new created db Roberto D. Maggi <robertodmaggi@gmail.com>
2022-02-08 15:21 ` Ron <ronljohnsonjr@gmail.com>
2022-02-08 17:08 ` Dan Smith <j.daniel.smith1@gmail.com>
2022-02-09 15:13 ` Roberto D. Maggi <robertodmaggi@gmail.com>
2022-02-09 15:17 ` Roberto D. Maggi <robertodmaggi@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox