database "public" does not exist - postgres/sequelize

Question

I'm trying to connect postgres database from sequelize (node.js).But sequelize throws error like ERROR: database "public" does not exist.

The database url is given below:

postgres://postgres:root@localhost:5432/public

The show db result is given below:

I have modified the database url as follows: postgres://postgres:root@localhost:5432/postgres, where postgres is valid database.Please find the attached image below:

database and schema in postgresql are not the same object .. you should provide the database name not the schema name — ScaisEdge
– ScaisEdge, Commented Dec 14, 2018 at 8:50
A database and schema are two different things. You connect to a database which in turn contains many schemas in which you create tables (and other objects). So, to create a table you provide a schema name. So you should use create table public.sequalizemeta ... — user330315
– user330315, Commented Dec 14, 2018 at 9:11
Please read meta.stackoverflow.com/questions/285551/… and the accepted answer — user330315
– user330315, Commented Dec 14, 2018 at 9:11

ScaisEdge · Accepted Answer · 2018-12-14 08:56:04Z

2

database and schema in postgresql are not the same object .. you should provide the database name not the schema name

you could get the list of the database using

psql -U pgadmin -l

answered Dec 14, 2018 at 8:56

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

Comments

Prabhatika Vij · Accepted Answer · 2022-11-19 04:57:45Z

0

The postgres database is a default database meant for use by users, utilities and third party applications.

If you don't specify a database while connecting to postgres (using, day, psql), it will connect to postgres DB.

It is possible that you connected to postgres without specifying the DB and created the tables. Hence they were created in postgres DB.

References:

answered Nov 19, 2022 at 4:57

Prabhatika Vij

3476 silver badges21 bronze badges

Collectives™ on Stack Overflow

database "public" does not exist - postgres/sequelize

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related