Lines Matching refs:tt1
302 CREATE VIEW tt1 AS
308 \d+ tt1
309 View "testviewschm2.tt1"
323 SELECT * FROM tt1;
330 SELECT a::varchar(3) FROM tt1;
337 DROP VIEW tt1;
339 CREATE TABLE tt1 (f1 int, f2 int, f3 text);
341 CREATE TABLE temp_view_test.tt1 (y1 int, f2 int, f3 text);
343 select * from tt1
344 where exists (select 1 from tx1 where tt1.f1 = tx1.x1);
346 select * from tt1 a1
349 select * from tt1
350 where exists (select 1 from tx1 a2 where tt1.f1 = a2.x1);
352 select * from temp_view_test.tt1
353 where exists (select 1 from tt1 where temp_view_test.tt1.y1 = tt1.f1);
362 SELECT tt1.f1,
363 tt1.f2,
364 tt1.f3
365 FROM tt1
368 WHERE tt1.f1 = tx1.x1));
381 FROM tt1 a1
394 SELECT tt1.f1,
395 tt1.f2,
396 tt1.f3
397 FROM tt1
400 WHERE tt1.f1 = a2.x1));
410 SELECT tt1.y1,
411 tt1.f2,
412 tt1.f3
413 FROM temp_view_test.tt1
415 FROM tt1 tt1_1
416 WHERE tt1.y1 = tt1_1.f1));
427 SELECT tt1.f1,
428 tt1.f2,
429 tt1.f3
430 FROM tt1
433 WHERE tt1.f1 = a1.x1));
446 FROM tt1 a1
459 SELECT tt1.f1,
460 tt1.f2,
461 tt1.f3
462 FROM tt1
465 WHERE tt1.f1 = a2.x1));
475 SELECT tt1.y1,
476 tt1.f2,
477 tt1.f3
478 FROM temp_view_test.tt1
480 FROM tt1 tt1_1
481 WHERE tt1.y1 = tt1_1.f1));
483 ALTER TABLE tt1 RENAME TO a2;
540 SELECT tt1.y1,
541 tt1.f2,
542 tt1.f3
543 FROM temp_view_test.tt1
546 WHERE tt1.y1 = a2.f1));
548 ALTER TABLE a1 RENAME TO tt1;
562 FROM tt1
563 WHERE a2.f1 = tt1.x1));
578 FROM tt1
579 WHERE a1.f1 = tt1.x1));
594 FROM tt1 a2_1
605 SELECT tt1.y1,
606 tt1.f2,
607 tt1.f3
608 FROM temp_view_test.tt1
611 WHERE tt1.y1 = a2.f1));
628 FROM tt1
629 WHERE tx1.f1 = tt1.x1));
644 FROM tt1
645 WHERE a1.f1 = tt1.x1));
660 FROM tt1 a2
671 SELECT tt1.y1,
672 tt1.f2,
673 tt1.f3
674 FROM temp_view_test.tt1
677 WHERE tt1.y1 = tx1.f1));
679 ALTER TABLE temp_view_test.tt1 RENAME TO tmp1;
695 FROM tt1
696 WHERE tx1.f1 = tt1.x1));
711 FROM tt1
712 WHERE a1.f1 = tt1.x1));
727 FROM tt1 a2