R
R
Roman Volodin2019-01-15 10:57:30
PostgreSQL
Roman Volodin, 2019-01-15 10:57:30

What is WITH when creating a user in Postgres?

What is WITH when creating a user?
What is the difference
CREATE USER username WITH PASSWORD 'password';
and
CREATE USER username PASSWORD 'password';
?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2019-01-15
@cronk

Garbage keyword for compatibility with the standard.
It does nothing, does nothing.
If you know how to read grammar: https://github.com/postgres/postgres/blob/REL_10_S... opt_with just below, no action already at the parser stage, what it is, what it is not.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question