On 01.03.21 11:12, Michael Banck wrote:
> postgres(at)kohn:~$ pg_dump --create-only -p 65432 -d test -h /tmp | egrep -v '^($|--|SET)'
> SELECT pg_catalog.set_config('search_path', '', false);
> CREATE DATABASE test WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'de_DE.UTF-8';
> ALTER DATABASE test OWNER TO postgres;
> \connect test
> SELECT pg_catalog.set_config('search_path', '', false);
> GRANT CONNECT ON DATABASE test TO test;
I find this option name confusing, because evidently it prints out
things that are not CREATE commands. For example, an intuitive idea of
"create only" might be to omit GRANT commands.