Re: [GENERAL] Issue dumping schema using readonly user

2015-02-19 Thread Daniel LaMotte
Thank you all so much for the feedback. At this point, I'm convinced that the issue is more complicated than I originally thought :) FWIW, my use case is for a company internal database. I open the database up to all users by simply having a "readonly" user that anyone can use to connect to the

Re: [GENERAL] Issue dumping schema using readonly user

2015-02-17 Thread Daniel LaMotte
p still asks for permission to read the table data in order to simply dump the schema (which is what I'm trying to confirm if its intentional or a bug) which results in permission denied error. - Dan On Tue, Feb 17, 2015 at 8:55 PM, Adrian Klaver wrote: > On 02/17/2015 03:11 AM, Daniel La

Re: [GENERAL] Issue dumping schema using readonly user

2015-02-17 Thread Daniel LaMotte
to be able to access the schema (at least interactively). Does that make more sense? - Dan On Fri, Feb 13, 2015 at 4:48 AM, Adrian Klaver wrote: > On 02/11/2015 01:47 PM, Daniel LaMotte wrote: > >> Here’s the situation: >> >> | % psql --version >> psql (P

[GENERAL] Issue dumping schema using readonly user

2015-02-12 Thread Daniel LaMotte
Here’s the situation: % psql --version psql (PostgreSQL) 9.3.5 % postgres --version postgres (PostgreSQL) 9.3.5 % psql mydatabase create table mytable_is_readonly (id uuid primary key, text text not null); create table mytable_is_not_readonly (id uuid primary key, text