|
From: Gabriel C. de O. <gab...@vi...> - 2016-01-22 16:50:20
|
I can; however, there isn't a "copy" option in the context menu when I select a view. 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 > ----------------------------------------------------------------------- > 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 |
