pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing Tables from another database.
5+ messages / 5 participants
[nested] [flat]
* Using Tables from another database.
@ 2002-07-25 13:36 Rogério Baldini das Neves <baldini@infoquest.com.br>
0 siblings, 2 replies; 5+ messages in thread
From: Rogério Baldini das Neves @ 2002-07-25 13:36 UTC (permalink / raw)
To: pgsql-sql
Hello,
I need to make a view like:
create view view_test as select * from mydb.mytable;
and I get this error:
ERROR: parser: parse error at or near "."
Whats the problem??
How can I solve this problem?
Thanks a lot,
Rogério Baldini
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using Tables from another database.
@ 2002-07-25 17:32 omid omoomi <oomoomi@hotmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: omid omoomi @ 2002-07-25 17:32 UTC (permalink / raw)
To: pgsql-sql
hi,
You may simply write:
create view view_test as select * from mytable;
But if the your table is in another database, then I am sorry. no way.
regards
Omid Omoomi
>From: Rogério Baldini das Neves <baldini@infoquest.com.br>
>To: <pgsql-sql@postgresql.org>
>Subject: [SQL] Using Tables from another database.
>Date: Thu, 25 Jul 2002 10:36:09 -0300
>
>Hello,
>
>I need to make a view like:
>
>create view view_test as select * from mydb.mytable;
>
>and I get this error:
>
>ERROR: parser: parse error at or near "."
>
>Whats the problem??
>
>How can I solve this problem?
>
>Thanks a lot,
>
>Rogério Baldini
>
>
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using Tables from another database.
@ 2002-07-25 17:36 Bruno Wolff III <bruno@wolff.to>
parent: Rogério Baldini das Neves <baldini@infoquest.com.br>
1 sibling, 0 replies; 5+ messages in thread
From: Bruno Wolff III @ 2002-07-25 17:36 UTC (permalink / raw)
To: Rogério Baldini das Neves <baldini@infoquest.com.br>; +Cc: pgsql-sql
On Thu, Jul 25, 2002 at 10:36:09 -0300,
Rogério Baldini das Neves <baldini@infoquest.com.br> wrote:
>
> How can I solve this problem?
The simplest answer is to pick a name that doesn't have a period in it.
If you are really trying to use schemas, you have to wait for 7.3.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using Tables from another database.
@ 2002-07-25 17:43 Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
parent: Rogério Baldini das Neves <baldini@infoquest.com.br>
1 sibling, 1 reply; 5+ messages in thread
From: Reinoud van Leeuwen @ 2002-07-25 17:43 UTC (permalink / raw)
To: pgsql-sql
On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini@infoquest.com.br
(Rogério Baldini das Neves) wrote:
>Hello,
>
>I need to make a view like:
>
>create view view_test as select * from mydb.mytable;
>
>and I get this error:
>
>ERROR: parser: parse error at or near "."
>
>Whats the problem??
This is possible in Sybase or Microsoft SQL server, not in Postgresql
(AFAIK)
--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen reinoud.v@n.leeuwen.net
http://www.xs4all.nl/~reinoud
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Using Tables from another database.
@ 2002-07-26 13:55 D'Arcy J.M. Cain <darcy@druid.net>
parent: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
0 siblings, 0 replies; 5+ messages in thread
From: D'Arcy J.M. Cain @ 2002-07-26 13:55 UTC (permalink / raw)
To: Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>; +Cc: pgsql-sql
* Reinoud van Leeuwen <reinoud.v@n.leeuwen.net> [020726 08:05]:
> On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini@infoquest.com.br
> (Rogério Baldini das Neves) wrote:
> >create view view_test as select * from mydb.mytable;
>
> This is possible in Sybase or Microsoft SQL server, not in Postgresql
> (AFAIK)
Yet. It's on the TODO list.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-07-26 13:55 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-07-25 13:36 Using Tables from another database. Rogério Baldini das Neves <baldini@infoquest.com.br>
2002-07-25 17:36 ` Bruno Wolff III <bruno@wolff.to>
2002-07-25 17:43 ` Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>
2002-07-26 13:55 ` D'Arcy J.M. Cain <darcy@druid.net>
2002-07-25 17:32 Re: Using Tables from another database. omid omoomi <oomoomi@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox