Friday, July 24, 2009

PostgreSQL and capitalization

The terminal-based PostgreSQL front-end psql, which ships standard, does not like capitalized table names.

ri=> \d KDplot_plotpoint
Did not find any relation named "KDplot_plotpoint"
ri=> \d "KDplot_plotpoint"
Table "public.KDplot_plotpoint"
Column | Type | Modifier
...

Double-quotes are your friends.

No comments: