From: | "Mark Wilson" <mark(at)mediasculpt(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | accessing schemas |
Date: | 2002-10-16 20:08:25 |
Message-ID: | 010201c2754f$cbda6930$3301a8c0@merl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I am using postgresql 7.2.1.
I'm trying to create two separate objects with the same name, a table and a view on the table. It seems like the best way to do this is to create two schemas and have the view reference the table in the other schema. But I have a problem. TO start with, it seems like psql is creating another database instead of another schema (e.g. CREATE SCHEMA TEST1; returns CREATE DATABASE). This is not the biggest problem in the world, although I had thought that schemas would be subordinate to databases (just like users :~)
Secondly, when I run "\c test2 testuser" to *connect* to the schema I want the view created in, where
running create view try1 as select * from test1.try1;
returns ERROR: parser: parse error at or near "."
How can I get the view in the test2 schema to reference the table in schema test1?
Thanks in advance,
Mark
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2002-10-16 20:10:35 | Re: accessing schemas |
Previous Message | James Hall | 2002-10-16 19:50:56 | Pg_dumpall problem |