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.l...@gmail.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.
