Re: [Squirrel-sql-users] Copy PostgreSQL table to MySQL using the ONLY clause

[John H. <jh...@im...>]

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
-----------------------------------------------------------------------
   Trusting in anti-gun laws to keep you from being shot is like
   refusing to wear your seatbelt because you trust traffic laws to
   keep you from being in a car accident.              -- Erin Palette
-----------------------------------------------------------------------
  Tomorrow: John Moses Browning's 161st Birthday