Maximum characters in labels (table names, columns etc)

by

You ask:

Is there a command that can change this maximum length? Is this length
the same for other names (columns, tables etc)?

The manual answers here:

The system uses no more than NAMEDATALEN-1 bytes of an identifier;
longer names can be written in commands, but they will be truncated.
By default, NAMEDATALEN is 64 so the maximum identifier length is 63 bytes. If this limit is problematic, it can be raised by changing the
NAMEDATALEN constant in src/include/pg_config_manual.h.

Bold emphasis mine.

The only way to change it is to hack the source code and recompile PostgreSQL.
Domain names are identifiers like any other. When I execute:

CREATE DOMAIN d_complement_activite_etablissement_or_even_loger_than_that AS text

I get what I ordered (tested on PostgreSQL 8.4 – 11):

d_complement_activite_etablissement_or_even_loger_than_that

There must be some other piece of software between you and your database cropping the name.

Note that characters in UTF encoding occupy 1 to 4 bytes. (But ASCII characters (like used in the example) are encoded with a single byte.)

More Related Contents:

  1. Cannot create a database table named ‘user’ in PostgreSQL
  2. PostgreSQL Error: Relation already exists
  3. Insert, on duplicate update in PostgreSQL?
  4. How does the search_path influence identifier resolution and the “current schema”
  5. How do you find the row count for all your tables in Postgres
  6. Run batch file with psql command without password
  7. invalid byte sequence for encoding “UTF8”
  8. Postgresql: Conditionally unique constraint
  9. How do you use variables in a simple PostgreSQL script?
  10. How to switch databases in psql?
  11. Postgresql: Scripting psql execution with password
  12. Postgresql Truncation speed
  13. Buffers (Circle) in PostGIS
  14. docker postgres pgadmin local connection
  15. How to customize the configuration file of the official PostgreSQL Docker image?
  16. Does a Postgres UNIQUE constraint imply an index?
  17. SELECT raises exception in PL/pgSQL function
  18. Heroku “psql: FATAL: remaining connection slots are reserved for non-replication superuser connections”
  19. Dynamically generate columns for crosstab in PostgreSQL
  20. Postgresql insert trigger to set value
  21. postgres autoincrement not updated on explicit id inserts
  22. Retrieving Comments from a PostgreSQL DB
  23. Docker – How can run the psql command in the postgres container?
  24. Postgis installation: type “geometry” does not exist
  25. PostgreSQL how to concat interval value ‘2 days’
  26. Displaying image in Ireports using PostgreSql
  27. Orbeon Forms Postgres DB connection
  28. How to delete an enum type value in postgres?
  29. Why unsigned integer is not available in PostgreSQL?
  30. now() default values are all showing same timestamp

Leave a Comment