Re: [GENERAL] pg_restore tells schema “test” already exists but it isn't actually

Try this instead:
SELECT current_database();
SELECT nspname FROM pg_namespace ORDER BY 1;

Also, What is the exact command you are using with pg_restore?

On Thu, Nov 12, 2015 at 9:53 PM, Alex Luya <alexander(dot)luya(at)gmail(dot)com> wrote:

> When restoring a dump like this:
>
> pg_restore --clean --create --exit-on-error --dbname=test test.tar
>
> these error messages got printed out:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 21; 2615 80924 SCHEMA test test
> pg_restore: [archiver (db)] could not execute query: ERROR: schema "test" already exists
> Command was: CREATE SCHEMA test;
>
> but when:
>
> select schema_name from information_schema.schemata;
>
> these got printed out
>
> schema_name --------------------
> pg_toast
> pg_temp_1
> pg_toast_temp_1
> pg_catalogpublic
> information_schema
>
> It seems like schema "test" doesn't exist yet,why do I got this kind of
> error?
>
>

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.