PostgreSQL. Is it possible to customize default naming?

Question

We have our long-used internal db naming conventions. For example: suffix for indexes is "_ix", for foreign key - "_fk".

These conventions are conflicting with default postgresql naming conventions: "_idx" for index and "_fkey" for foreign key.

For example. If i create index and don't define index name explicit like this CREATE INDEX ON a (id); then i'll get such index name: a_id_idx. But according to our conventions, which are used not only for postgresql, there must be a_id_ix.

The best way would be to change autogenerated naming pattern to match our conventions. Seems it should be simple but i can't find how it can be done.

Any solutions?

[I still think it is a bad idea,but] postgresql.org/docs/9.6/static/sql-alterindex.html ALTER INDEX [ IF EXISTS ] name RENAME TO new_name; — wildplasser
– wildplasser, Commented Sep 6, 2017 at 11:00
@CraigRinger, there are 2 reasons why i searching ability to change the defaults: 1. There is serial type (quite convenient) generating sequence with name {table_name}_{column_name}_seq and i can't define name explicitly without manual sequence creation 2. It is wrong to forbid using autogeneration at all if there is alternative. But if i can't change the postgres defaults at global level then probably i will have to add some rules in our conventions that prohibit the use of serial type and some other features. — keddok
– keddok, Commented Sep 6, 2017 at 11:21

Soni Harriz · Accepted Answer · 2017-09-06 09:26:02Z

0

CREATE INDEX index_name ON a (id);

answered Sep 6, 2017 at 9:26

Soni Harriz

3,6481 gold badge15 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

keddok Over a year ago

In some cases i can't define explicit name. For example: for serial column type postgresql generates sequence with name {table_name}_{column_name}_seq, but i need {table_name}_seq.

user330315 Over a year ago

@keddok: yes you can:

create sequence some_table_seq; create table some_table (id integer default nextval('some_table_seq')); alter sequence some_table_seq owned by some_table.id;

keddok Over a year ago

Thanks, @a_horse_with_no_name. But understand that there are other ways. I don't wanna prohobit the use of serial type, it is quite convenient. I just wanna to change defaults in postgresql.

user330315 Over a year ago

@keddok: then you need to change the Postgres source and compile your own version

Collectives™ on Stack Overflow

PostgreSQL. Is it possible to customize default naming?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related