Re: aliases for sequences and other DB objects?

Поиск
Список
Период
Сортировка
От Frank Heikens
Тема Re: aliases for sequences and other DB objects?
Дата
Msg-id DCEABA60-9735-4267-AA29-E1466400EEE5@mac.com
обсуждение исходный текст
Ответ на aliases for sequences and other DB objects?  (Agoston Postgres <agostonpostgres@yahoo.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Ioana Danes
Дата:
Сообщение: Re: Duplicate key issue in a transaction block
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: aliases for sequences and other DB objects?