-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 22 Jan 2008 15:11:30 -0300 "fernando gamba" <gamba.fernando@xxxxxxxxx> wrote: > i need to know if i can make a view which get data from another schema > or a link wich point to a table in another schema. Sure... assume the following: create schema foo; create table baz(id serial primary key) create view foo.myview as select * from public.baz; Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHljYEATb/zqfZUUQRAi6yAJ9VFFqjEkvPW9TpFCSi9knCpHUDwgCcCQke FfVRrIWWPHYTdDrxwKGevnA= =+pNY -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 5: don't forget to increase your free space map settings
