Sample Header Ad - 728x90

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