Thread: copy/paste table(s) - patch no.3

copy/paste table(s) - patch no.3

From
Vladimir Kokovic
Date:
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

Re: copy/paste table(s) - patch no.3

From
Ashesh Vashi
Date:
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

 

http://www.linkedin.com/in/asheshvashi




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