PostgreSQL SQL import fails with error as schema not found

Question

I am trying to import an SQL file as part of the database through PGAdmin3 but I am getting error as the schema not found. But when I try to select the namespace it list that schema.
Below is the output from the DB

test=# select nspname from pg_catalog.pg_namespace;
      nspname
--------------------
 pg_catalog
 pg_toast
 public
 pg_temp_1
 pg_toast_temp_1
 information_schema
 testschema
(7 rows)

Below is the sql commands which I am trying to run from script

CREATE TABLE TestSchema.Emp (
                lastname VARCHAR(50) NOT NULL,
                firstname VARCHAR(10) NOT NULL,
                empid INTEGER PRIMARY KEY
};

ERROR:  schema "testschema" does not exist
********** Error **********

ERROR: schema "testschema" does not exist
SQL state: 3F000

Any thoughts why this error is coming.

Are you sure you're looking at the same database both times? — Milen A. Radev
– Milen A. Radev, Commented Feb 24, 2014 at 9:28
When the pgadmin3 launch it ask me database which I provide it. But I don't know if it use "" for the DB Name as I have another DB which is created using quoted string. — Abhinav
– Abhinav, Commented Feb 24, 2014 at 10:46

Mladen Uzelac · Accepted Answer · 2014-11-07 11:43:15Z

1

You have a typo:

CREATE TABLE TestSchema.Emp (
                lastname VARCHAR(50) NOT NULL,
                firstname VARCHAR(10) NOT NULL,
                empid INTEGER PRIMARY KEY
}; -- Put ) instead of }

Normally it does not work

answered Nov 7, 2014 at 11:43

Mladen Uzelac

1,2611 gold badge11 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhinav Over a year ago

My bad I will fix the same and take a look again as I was learning PG programming but later didn't get much time to look into the issue.

Houari · Accepted Answer · 2014-02-24 09:30:02Z

0

Try to replace:

CREATE TABLE TestSchema.Emp (

By

CREATE TABLE testschema.Emp (

edited Feb 24, 2014 at 9:30

answered Feb 24, 2014 at 9:25

Houari

5,6513 gold badges33 silver badges57 bronze badges

1 Comment

Milen A. Radev Over a year ago

No, Postgres is not case-sensitive if the identifiers are not quoted.

Collectives™ on Stack Overflow

PostgreSQL SQL import fails with error as schema not found

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related