Return-Path: 
 <user-return-9519-apmail-hadoop-common-user-archive=hadoop.apache.org@hadoop.apache.org>
X-Original-To: apmail-hadoop-common-user-archive@www.apache.org
Delivered-To: apmail-hadoop-common-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id F1396CC71
	for <apmail-hadoop-common-user-archive@www.apache.org>;
 Sun, 21 Jul 2013 11:19:55 +0000 (UTC)
Received: (qmail 32438 invoked by uid 500); 21 Jul 2013 11:19:50 -0000
Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org
Received: (qmail 32072 invoked by uid 500); 21 Jul 2013 11:19:43 -0000
Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:user@hadoop.apache.org>
List-Id: <user.hadoop.apache.org>
Reply-To: user@hadoop.apache.org
Delivered-To: mailing list user@hadoop.apache.org
Received: (qmail 32008 invoked by uid 99); 21 Jul 2013 11:19:41 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jul 2013 11:19:41 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,WEIRD_PORT
X-Spam-Check-By: apache.org
Received-SPF: error (nike.apache.org: local policy)
Received: from [209.85.214.174] (HELO mail-ob0-f174.google.com)
 (209.85.214.174)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Jul 2013 11:19:35 +0000
Received: by mail-ob0-f174.google.com with SMTP id wd20so7140421obb.33
        for <user@hadoop.apache.org>; Sun, 21 Jul 2013 04:18:54 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=google.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type
         :x-gm-message-state;
        bh=Rog343fBnk0GfKYKUujUmapnbLoIIQ/ldvi4TztjmiA=;
        b=G6Yo9ATvizDrPqzzAwUwriuEbOzzn3R/5QJM/N6v3KY5SbY7AiyvrwuaHfY5M6hRtI
         10eR10AvEYUcmEYqw+X6TH8jCyFYVCGjeLwKRh1yqEblS528J1uwhAuxiJpGYWXy/7jH
         l4gNYA1W97Hd+sQodcxH+PhVpNlezMvuVyPxrR0dEKj3+MKNhwfMTEVtpDAVOxZjNQ7h
         unluBVCqztX2deBtOcwj5LTg8a17wtrKLDXBv2UQn5ru1upXC3H0kdV4ULMqGV4RD5Vw
         VuRIwsdJsLtrGAiauiPlb2gic1hF78e6NcVuiLLUsJiBfxs7epQTaQ4cKC3mjeZv64iu
         4FvQ==
MIME-Version: 1.0
X-Received: by 10.60.102.100 with SMTP id fn4mr23714382oeb.3.1374405533937;
 Sun, 21 Jul 2013 04:18:53 -0700 (PDT)
Received: by 10.60.148.198 with HTTP; Sun, 21 Jul 2013 04:18:53 -0700 (PDT)
Date: Sun, 21 Jul 2013 15:18:53 +0400
Message-ID: 
 <CAMe0HzR7W=o8EqPdt2mzY61+vKsHsB-+EB2-oq2k+cB6CgPG_Q@mail.gmail.com>
Subject: Data Import via Sqoop from Postgresql to HDFS
From: Fatih Haltas <fatih.haltas@nyu.edu>
To: "user@hadoop.apache.org" <user@hadoop.apache.org>,
	"user@sqoop.apache.org user@sqoop.apache.org" <user@sqoop.apache.org>
Content-Type: multipart/alternative; boundary=089e0111d842a0c7d604e203b91e
X-Gm-Message-State: 
 ALoCoQmN3RyhQR0eicFzHLppAdoAY7fRpojw92EOpKLpOPo4T7lf2fwxPsGQplsEtlLQyCyq6DRL
X-Virus-Checked: Checked by ClamAV on apache.org

--089e0111d842a0c7d604e203b91e
Content-Type: text/plain; charset=ISO-8859-1

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.

--089e0111d842a0c7d604e203b91e
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi everyone,<div><br></div><div>I had another problem whil=
e trying to import or list tables on postgresql via sqoop.=A0</div><div><br=
></div><div>I am using this command=A0</div><div><br></div><div>./sqoop lis=
t-databases --connect jdbc:postgresql://<a href=3D"http://192.168.194.158:5=
432/pgsql">192.168.194.158:5432/pgsql</a> --username pgsql -P</div>
<div><br></div><div>It does see only the tables under the public schema, ot=
her are not listed. i tried to change postgresql user settings now, actuall=
y is there any options to list all tables in my database in sqoop?=A0</div>
<div><br></div><div>OR I need to struggle with user-rights in postgresql?</=
div><div><br></div><div>Thanks.=A0</div></div>

--089e0111d842a0c7d604e203b91e--