Обсуждение: aliases for sequences and other DB objects?
| 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 |
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
Agoston Postgres wrote:
> Hi!
>
> Is it possible in Postgres to specify aliases for various DB objects, such as tables, views, sequences, etc.? (For
nowI 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');
No. What would this be used for?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.