Is there any --schema option to be able to list schemas other than public, because, I am not able to list other tables under non-public schemas?
On Mon, Jul 22, 2013 at 12:39 PM, Fatih Haltas <fatih.hal...@nyu.edu> wrote: > Hi Jarek, > > Thanks for your help. But I am using sqoop 1.4.3 but --schema version did > not work for me. > > > On Sun, Jul 21, 2013 at 6:54 PM, Jarek Jarcec Cecho <jar...@apache.org>wrote: > >> Hi Fatih, >> The list-database tool seems to be working with only one schema at the >> time. You can specify extra argument --schema to specify schema other than >> the default "public", for example: >> >> sqoop list-tables --connect ... -- --schema private_schema >> >> Jarcec >> >> On Sun, Jul 21, 2013 at 03:18:53PM +0400, Fatih Haltas wrote: >> > Hi everyone, >> > >> > I had another problem while trying to import or list tables on >> postgresql >> > via sqoop. >> > >> > I am using this command >> > >> > ./sqoop list-databases --connect jdbc:postgresql:// >> > 192.168.194.158:5432/pgsql --username pgsql -P >> > >> > It does see only the tables under the public schema, other are not >> listed. >> > i tried to change postgresql user settings now, actually is there any >> > options to list all tables in my database in sqoop? >> > >> > OR I need to struggle with user-rights in postgresql? >> > >> > Thanks. >> > >
