Re: Syntax To Create Table As One In Another Database

On 11/15/11 8:42 AM, Rich Shepard wrote:
>   I need a pointer to the appropriate docs that show me how to specify a
> table in a different database.
>
>   What I want is to CREATE TABLE <tablename> AS TABLE
> <otherdatabase><same_tablename>; but using a period (dot) to separate the
> source database and table name doesn't work. My searches of the 9.0.x
> docs
> have missed finding this information.


use Schemas instead of databases if this is what you need.   Combined
with search_path, this will get you the exact results you're looking
for.  in fact, the default search_path is $USER,public, so it will look
in a schema named after the current user before it looks in the default
schema...


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast