Postgres Pro
Downloads
Home   >   mailing lists

$user namespace with pg_dump? - Mailing list pgsql-general

From Mark E. Haase
Subject $user namespace with pg_dump?
Date
Msg-id CALb0Rk5dtnMjWfKB+h9bLeezi3A62n6SnBwDGAwiCD-8JzMObg@mail.gmail.com
Whole thread Raw
Responses Re: $user namespace with pg_dump?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
I can `SET search_path TO "$user",foo,bar,public` and the first path element will expand to the current user.

Can I do the same for `pg_dump -n`? I've tried many variations but none of them appear to work:

    pg_dump -U myuser -n '($user|foo|bar|public)' ...
    pg_dump -U myuser -n '("$user"|foo|bar|public)' ...
    pg_dump -U myuser -n '(\$user|foo|bar|public)' ...

I can't tell if I'm doing something wrong or if $user expansion is just some magic in SET that doesn't exist in pg_dump or `\dn`.

(The workaround is obvious, of course: replace $user with the value of the -U argument . This is a question of curiosity, not practicality.)

Also, is there any difference between `pg_dump -n '(foo|bar)'` and `pg_dump -n foo -n bar`? In my narrow testing, they produce identical results.

Thanks,

--
Mark E. Haase

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: bloated postgres data folder, clean up
Next
From: Alexander Farber
Date:
Subject: Re: How to ensure that a stored function always returns TRUE or FALSE?