Re: Synonym - Mailing list pgsql-general

From will trillich
Subject Re: Synonym
Date
Msg-id 20010511164119.D18098@serensoft.com
Whole thread Raw
In response to Synonym  (snpe <snpe@infosky.net>)
List pgsql-general
On Fri, May 11, 2001 at 02:04:18PM +0200, snpe wrote:
> Hello,
>     Can I created synonym for tables,views,functions ... in postgresql ?

well you can create a view which simulates a table:

    create view clone as
        select * from originaltable;

but that may not be what you're after.

--
don't visit this page. it's bad for you. take my expert word for it.
http://www.salon.com/people/col/pagl/2001/03/21/spring/index1.html

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PL/Perl without shared libperl.a
Next
From: will trillich
Date:
Subject: Re: single quotes in a select statement