Re: aliases for sequences and other DB objects?

Поиск
Список
Период
Сортировка
Искать

Re: aliases for sequences and other DB objects?

От:
Alvaro Herrera <alvherre@commandprompt.com>
Дата:
Agoston Postgres wrote:
> 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');

No.  What would this be used for?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

aliases for sequences and other DB objects?

От:
Agoston Postgres <agostonpostgres@yahoo.com>
Дата:
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

Re: aliases for sequences and other DB objects?

От:
Frank Heikens <frankygoestorio@mac.com>
Дата:
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


FAQ