Re: aliases for sequences and other DB objects?

From: Frank Heikens <frankygoestorio(at)mac(dot)com>
To: Agoston Postgres <agostonpostgres(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: aliases for sequences and other DB objects?
Date: 2009-06-09 20:20:36
Message-ID: DCEABA60-9735-4267-AA29-E1466400EEE5@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No, it's not possible, pgSQL does't have a CREATE ALIAS -syntax

You could put this function into another function to create sort of an
alias, but that wouldn't make to much sense.

Frank

Op 9 jun 2009, om 22:03 heeft Agoston Postgres het volgende geschreven:

> Hi!
>
> Is it possible in Postgres to specify aliases for various DB
> objects, such as tables, views, sequences, etc.? (For now I would
> like to create them for sequences.)
>
> What I mean is something like in Oracle, such as
>
> create alias my_sequence_alias for my_sequence;
> select nextval('my_sequence_alias');
>
>
> Thanks!
>
> Agoston
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2009-06-09 20:26:58 Re: Duplicate key issue in a transaction block
Previous Message Agoston Postgres 2009-06-09 20:03:51 aliases for sequences and other DB objects?