I'm trying to use Spring Roo for the first time to generate the code using the reverse engineering.
After installing the Postgresql addon by:
osgi install --url
http://spring-roo-repository.springsource.org/release/org/springframework/roo/wrapping/org.springframework.roo.wrapping.postgresql-jdbc3/8.4.701.0001/org.springframework.roo.wrapping.postgresql-jdbc3-8.4.701.0001.jar
I try the next command:
database introspect --schema USER
I'm sure that i have the USER schema in my database (when i use the TAB key, i get USER with other shema names with the right case-sensitivity) but spring response was:
roo> database introspect --schema
USER information_schema pg_catalog
pg_toast_temp_1 public
roo> database introspect --schema USER
Schema 'USER' does not exist or does not have any tables. Note that the schema names of some databases are case-sensitive