| Lists: | pgsql-adminPostg사설 토토SQLpgsql-in-generalpgsql-novicePostg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2012-03-06 이후 PGSQL-SQL 06:22pgsql-www |
|---|
| From: | Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-www(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | pg_dump : no tables were found. |
| Date: | 2012-03-06 06:22:39 |
| Message-ID: | CAFOD=KDDo4GWB43JvJ4S+ht_V0oGr0gQNRg6=X_FmyDRrZ1q0Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin Postg사설 토토SQL pgsql-in-general pgsql-novice Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2012-03-06 이후 PGSQL-SQL 06:22 pgsql-www |
Hi,
I m trying to take backup of data of a particular table using pg_dump.
I used double quotes for table name but output is :
pg_dump : no tables were found.
Command used :
-h localhost -p 5432 -U postgres -W -F p -a -t '"TestTable"' -f
DbBackup/BackupTableActions.sql TestDataBase
This problem only shows when there is a upper case character in my table
name.
Please Help
Thanks & Regards
Piyush
| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, pgsql-in-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org, pgsql-www(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: [ADMIN] pg_dump : no tables were found. |
| Date: | 2012-03-06 10:44:38 |
| Message-ID: | CAOBaU_YibH_fnGAUixNEo2NkmD2CjiCAt=Ez3uLSjNXL28U6VQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin pgsql-general pgsql-in-general pgsql-novice pgsql-sql pgsql-www |
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> wrote:
> Hi,
>
> I m trying to take backup of data of a particular table using pg_dump.
> I used double quotes for table name but output is :
> pg_dump : no tables were found.
>
> Command used :
> -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTable"' -f
> DbBackup/BackupTableActions.sql TestDataBase
>
> This problem only shows when there is a upper case character in my table
> name.
> Please Help
>
> Thanks & Regards
> Piyush
>
Hi
You can try -t '"TestTable"' or -t \"TestTable\"