2 -- Created by SQL::Translator::Producer::PostgreSQL
3 -- Created on Fri May 28 08:01:56 2010
8 DROP TABLE "just_a_table" CASCADE;
9 CREATE TABLE "just_a_table" (
11 "name" character varying(255) NOT NULL,
18 DROP TABLE "mixin" CASCADE;
19 CREATE TABLE "mixin" (
21 "words" text NOT NULL,
28 DROP TABLE "baz" CASCADE;
32 CREATE INDEX "baz_idx_b" on "baz" ("b");
38 CREATE VIEW "bar" ( "id", "a", "b" ) AS
39 select * from just_a_table
46 CREATE VIEW "foo" ( "id", "a" ) AS
47 select * from just_a_table
51 -- Foreign Key Definitions
54 ALTER TABLE "baz" ADD FOREIGN KEY ("b")
55 REFERENCES "just_a_table" ("id") DEFERRABLE;