Hi Tiffany,
Please share the exact steps you're following. What is the error you're
getting on restore?
On Wed, Jan 4, 2023 at 3:10 PM Tiffany wrote:
> Good afternoon, I am taking a SQL course with Udemy and when I try to
> restore the pgadmin app, it doesn't appear. I have uninstalled/reinstal
On 04/01/2023 13:53, Tiffany wrote:
Hello, I’m on Windows. I installed pgadmin through Chrome, I hope that
answers your question. When I try to restore, I don’t even see the
pgadmin app available on my end and it keeps just re-installing. I only
have the pgadmin exe available, not the pgadmin a
Sure thing Yogesh. This is extracted from a schema-only dump of schema
p_atlas_mn:
CREATE SCHEMA p_atlas_mn;
ALTER SCHEMA p_atlas_mn OWNER TO p_atlas_mn;
GRANT USAGE ON SCHEMA p_atlas_mn TO select_any_table_role;
GRANT USAGE ON SCHEMA p_atlas_mn TO ro_any_table;
ALTER DEFAULT PRIVILEGES FOR ROLE
Hi,
We have installed PGAdmin 4 on another server and copied pgadmin4.db as an
export - import methode to create the existing connections. When we start
PGadmin all the icons are missing, at the original location they are still
there. Do you have an idea what went wrong?
[cid:image001.png@01D9
Hi Steve,
Could you please provide DDL for schema & database?
I could not reproduce the issue. Here is my schema DDL -
CREATE SCHEMA IF NOT EXISTS test123
AUTHORIZATION postgres;
GRANT CREATE ON SCHEMA test123 TO postgres;
GRANT USAGE ON SCHEMA test123 TO postgres WITH GRANT OPTION;
GRANT C
Hi Yogesh. Should’ve clarified that this is for any & all schemas.
Not sure if this image attachment will come through, but if you click on any of
the 79 schemas for this database in the browser when the SQL tab is active, you
get the error:
[cid:image001.png@01D920E5.27F24A10]
Ditto if you ri
Hi,
Could you please provide DDL for schema? and Can you please share output
for below queries -
1.SELECT defaclobjtype, pg_catalog.aclexplode(defaclacl) as acl FROM
pg_catalog.pg_namespace nsp LEFT OUTER JOIN pg_catalog.pg_default_acl dacl
ON (dacl.defaclnamespace = nsp.oid) WHERE nsp.oid=::oid