I'm working on an existing project that uses a postgresql database. This is my first time working with postgresql.
I have one major issue that is completely blocking me.
In the database creation script, I have the following lines:
CREATE TABLE "TA_cat_group" (
cat character varying NOT NULL,
group character varying NOT NULL
List of relations
Schema | Name | Type | Owner
public | TA_cat_group | table | vit
public | cat | table | vit
Did not find any relation named "TA_cat_group".
Due to the double quotes your table name is now case sensitive.
"TA_cat_group" is a different name then
You need to use
I would however recommend to never use double quotes in your SQL statements to avoid having to cope with case-sensitive names.
More details in the manual:
Unrelated, but: you can't use
group as a column name without enclosing it in double quotes because it is a reserved keyword. Your example
create table in your question will result in:
ERROR: syntax error at or near "group"
The only way to avoid that error would be to use
"group" instead of
group - but that however would use those dreaded double quotes.