Questions tagged [identifier]
The identifier tag has no usage guidance.
7
questions
1
vote
1answer
640 views
Relation does not exist while scanning schema
My Postgres database is getting slow while executing some function. But another database of identical design and with more data is much faster than the first one. I have recently migrated data from MS ...
7
votes
4answers
5k views
Why can't object names start with a number?
For example, if I'm creating view with a name '4aii', why does SQL Server care that it starts with a 4? I could call the table Fouraii or IVaii.
Additionally, what does [] do behind the scenes to ...
2
votes
1answer
124 views
Does the SQL-1992 standard restrict naming identifiers to 18 characters?
In this draft of SQL:1992, I found…
Section 5.2
Leveling Rules
....
The following restrictions apply for Entry SQL in addition to any Intermediate SQL restrictions:
a) No <...
0
votes
1answer
807 views
How do I adopt the PostgreSQL naming convention in legacy database?
I realize I'll need to update the queries, but if I have a database that has camelCase or spaces in it, you have to use double quotes on the identifiers (viz. schema, table, column). How do I migrate ...
3
votes
1answer
186 views
Test if a string is a valid, unquoted identifier?
I'm just wondering if there is an established method for testing if a string can be used as an unquoted PostgreSQL identifier? (unquoted because almost any string can be a quoted identifier).
I ask ...
4
votes
2answers
1k views
Does this regex reliably remove square brackets from T-SQL?
I'm using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex).
I need a regex expression that can reliably remove square ...
1
vote
1answer
102 views
What do we call the equivalent of CSS “Specificity” in SQL?
In CSS, the more HTML elements you specify, the more precedence the selector gets. This is known as "specificity." For example,
div p span {...}
Is more specific than, and thus would override:
span ...
