Re: [GENERAL] Creating views (Multiple Databases)

2006-02-01 Thread A. Kretschmer
am 01.02.2006, um 23:05:43 -0800 mailte Benjamin Arai folgendes: > Hi, > > Is it possible to create a view from two different database tables? -- Yes, with dblink 08:17 < akretschmer> ??dblink 08:17 < rtfm_please> For information about dblink 08:17 < rtfm_please> see http://developer.postgres

Re: [GENERAL] Creating views (Multiple Databases)

2006-02-01 Thread Michael Glaesemann
On Feb 2, 2006, at 16:05 , Benjamin Arai wrote: Is it possible to create a view from two different database tables? Yes. You can create a view out of any query (i.e., SELECT statement). For example, CREATE VIEW companies__members__view AS SELECT company.company_name, member.given_name, me

[GENERAL] Creating views (Multiple Databases)

2006-02-01 Thread Benjamin Arai
Hi, Is it possible to create a view from two different database tables?  -- Benjamin Arai [EMAIL PROTECTED] http://www.benjaminarai.com