Postgres Relation Does not Exist

Using Django Using the ORM
1

OK so i have the following settings and models in my django file.

Settings.py file

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',

    'NAME': 'prods1',

    'USER': 'Username',

    'PASSWORD': 'Password',

    'HOST': 'localhost',

    'PORT': 5432,
}

}

Models FIle:

class Retailers(models.Model):

Links = models.CharField(max_length=500,unique=True)

Title = models.CharField(max_length=300)

Images = models.TextField()

Color = models.CharField(max_length=40)



def __str__(self):
	
	return self.Title

Now i have even entered the data into the models and have even shows it on my Test website.

but now i went to check my data on PostgreSQL (Through terminal)

But it says relation does not exist. Please Help

Screenshots For Proof:

786Ă—533 67.7 KB

786Ă—533 20.4 KB

2

Capitalization is significant. Compare what you’ve entered with what PostgreSQL is telling you is the name of the table. (Also note that this is not a Django issue.)

3

hi yes i tried without capitalization and with it, still get this error.

Well django shoes the data on the website, i was just trying to show it in my terminal, but relation does not exist :frowning:

4

i also deleted the database removed migrations, made the database again, and inserted data, but still same problem

5

Look really carefully at the capitalization of the table name compared to what you entered.

6

yes i tried Prods_retailers.

does not work :frowning:

7

Ok, do me a favor please - copy/paste the text from the \dt command as well as the text from the select statement, not an image. (It’s going to be easier to quote / demonstrate what’s happening here that way.)

8

Alrite, Here it is

Prods_retailers

select * from Prods_retailers;

prods1=# select * from Prods_retailers;
ERROR: relation “prods_retailers” does not exist
LINE 1: select * from Prods_retailers;

9

Notice what you entered vs what PSQL iterprets it as.

The PSQL docs will tell you that unquoted names are case insensitive. You need to specify the table name quoted in this case.
e.g. select * from "Prods_retailers";

10 
prods1=# \dt
                  List of relations
 Schema |            Name            | Type  | Owner  
--------+----------------------------+-------+--------
 public | Prods_retailers            | table | firaki
 public | auth_group                 | table | firaki
 public | auth_group_permissions     | table | firaki
 public | auth_permission            | table | firaki
 public | auth_user                  | table | firaki
 public | auth_user_groups           | table | firaki
 public | auth_user_user_permissions | table | firaki
 public | django_admin_log           | table | firaki
 public | django_content_type        | table | firaki
 public | django_migrations          | table | firaki
 public | django_session             | table | firaki
(11 rows)

prods1=# select * from Prods_retailers;
ERROR:  relation "prods_retailers" does not exist
LINE 1: select * from Prods_retailers;
11

Sorry, timing issue - see response above your most recent comment.

1 Like
12

thank you thank you so much, God bless you :slight_smile:

13

visit this link, I believe that the answer provided will help you:

14

@lordihm Welcome to the Django forum!

Two notes I’d like to pass along -

First, this issue was resolved - see the message directly above your post.

Second, the linked post doesn’t have anything to do with the symptoms as fully described here in this thread and does not provide additional useful information to those reading this thread in the future.

15

Sorry! But I solved this problem by the procedure indicated. Because for my case the error is caused because actually the migration is not taking place. This is caused by not adding the app name to the end of the command. Hi

16

@lordihm I’m sure that’s true - however, the situation that you encountered is not related to the issue being addressed by this thread. (That is why you’ll see that it is recommended that each person open up a new topic for problems they are looking for assistance with.)