Hi All,
“Total n00b” here again.
I am using PostgreSQL 9.6.
I decided to move (not copy so at this moment “public” is now empty) my tables from the “public” schema in PostgreSQL (9.6) to a new schema (“abc”).
That worked without fault.
So I created a new connection, referenced the new schema, tested it, no issues.
Now I go to create the new data dictionary and it can’t see any of the tables in the new schema. No matter what options I choose and no matter if I drop / create the data dictionary. No tables found.
I copied (not moved) the tables into public.
Now no data dictionary can see the tables in either schema.
So I dropped the new schema.
Still didn’t work.
I am going nuts ~ anyone have any thoughts?
Thanks.