Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_misc=# create schema test1;
CREATE SCHEMA
soport
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_mi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
in a database I created a schema, but as superuser or as an user of that
schema I'm unable to see a listing of the schema contents. I'm running
postgresql 8.2.5, compiled via macports under Mac OS X 10.4.10 commands
and output follows:
soporte_mi
Euler Taveira de Oliveira wrote:
> Gabriel Ramirez wrote:
>
>> so seems if one don't specified the schemaname.objects to list the
>> database don't return them, or maybe I'm missing a step after creating
>> the schema and objects to be able to list them.
Hello,
By documentation advice in:
http://www.postgresql.org/docs/8.3/interactive/role-attributes.html
Tip: It is good practice to create a role that has the CREATEDB
and CREATEROLE privileges, but is not a superuser, and then use this
role for all routine management of databases and roles. T
