On 2005-10-19, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote:
> Suppose I have a database with a table in it. I try to dump that
> database. The user I dump as is not the owner of that table nor does it
> have the SELECT permission on that table.
>
> Why can't I do a schema-only dump of tha
Suppose I have a database with a table in it. I try to dump that
database. The user I dump as is not the owner of that table nor does it
have the SELECT permission on that table.
Why can't I do a schema-only dump of that table? I find that I need
SELECT permission on the table, even though
Tom Lane wrote:
> Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> > My live 7.3.4 database dumps data like this:
>
> > REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC;
> > GRANT ALL ON TABLE log_freeprofile TO brett;
> > GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO "au-php";
> > GR
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> My live 7.3.4 database dumps data like this:
> REVOKE ALL ON TABLE log_freeprofile FROM PUBLIC;
> GRANT ALL ON TABLE log_freeprofile TO brett;
> GRANT INSERT,SELECT,UPDATE ON TABLE log_freeprofile TO "au-php";
> GRANT SELECT ON TABLE log_freepr
Hi guys,
My live 7.3.4 database dumps data like this:
SET SESSION AUTHORIZATION 'auadmin';
--
-- TOC entry 346 (OID 1012952)
-- Name: log_freeprofile; Type: TABLE; Schema: public; Owner: auadmin
--
CREATE TABLE log_freeprofile (
date date DEFAULT ('now'::text)::date NOT NULL,
"start" int
