SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE test_original_name AS SELECT g.id FROM generate_series(1, 10, 1) AS g(id); CREATE VIEW select_from_original_table AS SELECT id FROM test_original_name; SELECT * FROM select_from_original_table; ALTER TABLE IF EXISTS test_original_name RENAME TO test_original_name_old; SELECT * FROM select_from_original_table; CREATE TABLE test_original_name AS SELECT g.id FROM generate_series(1, 5, 1) AS g(id); SELECT * FROM select_from_original_table; SELECT * FROM test_original_name; CREATE or replace VIEW select_from_original_table AS SELECT id FROM test_original_name; SELECT * FROM select_from_original_table;