Thread: copy/paste table(s) - patch no.3
Hi, 1. --- NEW FUNCTIONALITY FOR SCHEMA: Right click on schema node provides three new functionalities - Copy tables - Copy table(s) from the list - Paste table(s) "Copy tables" provides copying all tables from the schema. "Paste table(s)" on target schema will create new table(s) in target schema. New table(s) in target schema can be created with the same or new name(s). If name of source table exists in target schema then dialog for table name change will pop up and suffix for name should be added. Copy table(s) from the list provides copying selected table(s) from one or more schema on same or different server(even not connected - connection will be done automatically). NEW FUNCTIONALITY FOR TABLES Right click on table node provides three new functionalities - Copy table - Copy table with optional select clause - Copy table(s) from the list "Copy table" provides copying of one table. With "Copy table with optional select clause" provides copying table with filter option if only some data from the table should be included in new table. "Copy table(s) from the list" has the same functionality as the "Copy table(s) from the list" in schema. Paste table(s) has to be done on target schema. With Copy-Paste functions all table characteristics will be copied, that includes table definitions, constraints and data. Best regards Vladimir Kokovic Belgrade, Serbia, 21.October 2012
Attachment
Sorry for late reply.
--

I got this error while compiling the patch.
utils/pasteTables.cpp:12:34: error: utils/PgadminScanner.h: No such file or directory
utils/pasteTables.cpp: In member function ‘virtual wxString pgRuleCopyPaste::GetSql(ctlTree*)’:
utils/pasteTables.cpp:2135: error: ‘qualified_identifier_dot_pos_cpp’ was not declared in this scope
utils/pasteTables.cpp:2161: error: ‘scan_SQL_cpp’ was not declared in this scope
utils/pasteTables.cpp:2165: error: ‘parse_rule_cpp’ was not declared in this scope
utils/pasteTables.cpp:2171: error: ‘destroylist_cpp’ was not declared in this scope
utils/pasteTables.cpp: In member function ‘virtual wxString pgTriggerCopyPaste::GetSql(ctlTree*)’:
utils/pasteTables.cpp:2212: error: ‘qualified_identifier_dot_pos_cpp’ was not declared in this scope
make[3]: *** [utils/pasteTables.o] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
Please use the camel-case for name and avoid using struct (use class instead).
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company

On Sun, Oct 21, 2012 at 1:53 PM, Vladimir Kokovic <vladimir.kokovic@gmail.com> wrote:
Hi,
1.
---
NEW FUNCTIONALITY FOR SCHEMA:
Right click on schema node provides three new functionalities
- Copy tables
- Copy table(s) from the list
- Paste table(s)
"Copy tables" provides copying all tables from the schema.
"Paste table(s)" on target schema will create new table(s) in target schema.
New table(s) in target schema can be created with the same or new name(s).
If name of source table exists in target schema then dialog for table
name change will pop up and suffix for name should be added.
Copy table(s) from the list provides copying selected table(s) from
one or more schema on same or different server(even not connected -
connection will be done automatically).
NEW FUNCTIONALITY FOR TABLES
Right click on table node provides three new functionalities
- Copy table
- Copy table with optional select clause
- Copy table(s) from the list
"Copy table" provides copying of one table.
With "Copy table with optional select clause" provides copying table
with filter option
if only some data from the table should be included in new table.
"Copy table(s) from the list" has the same functionality as the "Copy
table(s) from the list" in schema.
Paste table(s) has to be done on target schema.
With Copy-Paste functions all table characteristics will be copied,
that includes table definitions, constraints and data.
Best regards
Vladimir Kokovic
Belgrade, Serbia, 21.October 2012
--
Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers