How to check if string is a valid postgres name?

Question

How to check if provided string is a valid name in postgres ? I know that it is possible to use any string as name when it is quoted, but I want to know is string can be used without quotes i.e. as role name. I have idea to do it like this: BEGIN; CREATE ROLE ; ROLLBACK; Is is good idea ?

user330315 · Accepted Answer · 2020-02-29 21:59:42Z

5

You can use the function quote_ident() which will quote a string only if necessary.

So if the "quoted" value is the same as the input, it's a legal identifier:

select quote_ident('foobar') = 'foobar'

returns true, however

select quote_ident('foo bar') = 'foo bar'

returns false.

answered Feb 29, 2020 at 21:59

user330315

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

Collectives™ on Stack Overflow

How to check if string is a valid postgres name?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related