Re: [Squirrel-sql-users] Copy PostgreSQL table to MySQL using the ONLY clause
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: John H. <jh...@im...> - 2016-01-22 18:35:05
|
On Fri, 22 Jan 2016, Gabriel Corrêa de Oliveira wrote: > I can; however, there isn't a "copy" option in the context menu when I > select a view. Select the table, do Copy, and modify the SQL to use the view name? (I'm shooting in the dark, I've never used that option.) > On Fri, Jan 22, 2016 at 2:47 PM, John Hardin <jh...@im...> wrote: > >> On Fri, 22 Jan 2016, Gabriel Corrêa de Oliveira wrote: >> >> I need to copy tables from PostgreSQL to MySQL, but I need Squirrel to add >>> the ONLY clause to every SELECT statement that it performs against the >>> PostgreSQL database. >>> >>> Example: SELECT * FROM ONLY MY_TABLE >>> >>> This is needed because I have descendant tables whose data I can't import >>> into the destination database. >>> >>> It is also necessary because if the SELECTs are performed without the ONLY >>> clause, it will read data from descendant tables and some unique keys will >>> be violated in the destination database. >>> >>> Does anybody know how I can achieve this? >>> >> >> Can you define a view with the ONLY and query from that? -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jh...@im... FALaholic #11174 pgpk -a jh...@im... key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Where We Want You To Go Today 07/05/07: Microsoft patents in-OS adware architecture incorporating spyware, profiling, competitor suppression and delivery confirmation (U.S. Patent #20070157227) ----------------------------------------------------------------------- Tomorrow: John Moses Browning's 161st Birthday |