Why can't I access some tables in postgresql
0
votes
0
answers
56
views
I am running into some strange problem in PostgreSQL
$ sudo -u postgres psql Blogging
psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
Type "help" for help.
Blogging=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------+-------+-------
public | Blogs | table | e
public | Posts | table | e
public | __EFMigrationsHistory | table | e
(3 rows)
Blogging=# select * from Blogs
Blogging-# ;
ERROR: relation "blogs" does not exist
LINE 1: select * from Blogs
^
The same problem occurs when I log in as the owner of the tables:
$ psql -U e Blogging
psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
Type "help" for help.
Blogging=# \dt
List of relations
Schema | Name | Type | Owner
--------+-----------------------+-------+-------
public | Blogs | table | e
public | Posts | table | e
public | __EFMigrationsHistory | table | e
(3 rows)
Blogging=# select * from Blogs;
ERROR: relation "blogs" does not exist
I created the database when running my application which uses Entity Framework, following https://learn.microsoft.com/en-us/ef/core/get-started/?tabs=netcore-cli . But I had some problem with the application, not sure if they are related to my question here.
Asked by Tim
(149 rep)
Jan 10, 2020, 06:52 AM
Last activity: Jan 10, 2020, 06:55 AM
Last activity: Jan 10, 2020, 06:55 AM