Identifier max length - PostgreSQL Database

Birahim FALL

Hi,
Certainly a stupid question : What is the max length for identifiers.
A test shows me 63 for a table name.
I just imagine it's the same for constraint name, view name etc ... but
I'm not sure.
Or where can I get this info, because it's not in the Postgresl docs !
Thanks

Nov 12 '05 #1

Subscribe Reply

3509

Bruce Momjian

Birahim FALL wrote:

Hi, Certainly a stupid question : What is the max length for
identifiers. A test shows me 63 for a table name. I just
imagine it's the same for constraint name, view name etc ...
but I'm not sure. Or where can I get this info, because it's
not in the Postgresl docs ! Thanks

Yep, all 63 limit. Not sure where it is documented.

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #2

Dennis Gearon

Bruce Momjian wrote:

Birahim FALL wrote:

Hi, Certainly a stupid question : What is the max length for
identifiers. A test shows me 63 for a table name. I just
imagine it's the same for constraint name, view name etc ...
but I'm not sure. Or where can I get this info, because it's
not in the Postgresl docs ! Thanks

Yep, all 63 limit. Not sure where it is documented.

The lengths can be found in 7.3.2 manauls at: (kinda haphazard)
----------------------------------------------
Tutorial - Section 1.3 pg 3
Reference - Section CREATE OPERATOR pg 2 of section
Reference - Section LISTEN pg 2 of section
Reference - Section NOTIFY pg 2 of section
Admin - Appendix A- Section 3.1 - pg 108
Admin - Appendix A- Section 3.3.5 - pg 111
User - Section 1.1.1 pg 2
User - Section 1.1.1 pg 5
User - Section 5.3 pg 58

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #3

Similar topics

3869

identifier length in C#

by: jim | last post by:

what is the maximum identifier length in C#? is it documented somewhere?

C# / C Sharp

4136

error C2146: syntax error : missing ';' before identifier 'Length'

by: IceColdFire | last post by:

I have a VC++.net Win32 console application, however when I compile , I get this error error C2146: syntax error : missing ';' before identifier 'Length' Explain... Location pointed is typedef struct _LIST

.NET Framework

2050

zero-length delimited identifier in pg_dumpall file

by: Randall Smith | last post by:

Got this error on a pg_dumpall file dumped from a postgresql-7.4-0.3PGDG database and imported into 7.4.5-3 database. ERROR: zero-length delimited identifier at or near """" at character 37 From looking at the output, I think maybe this is the line that caused the error. CREATE SCHEMA "MSV80" AUTHORIZATION "";

PostgreSQL Database

21755

The identifier that starts with...is too long. Maximum length is 128

by: Pedro | last post by:

Hi, i'm trying to run a stored procedure: "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT', '2006-02-01 00:00:00', '2006-02-28 00:00:00'" and gives me this error: The identifier that starts with "EXECUTE dbname.dbo.spGid 'KFT', '0000000011,0000000012', 'merch,DSMT', '2006-02-01 00:00:00', '2006-02-28 00:00:00'"

Microsoft SQL Server

7852

BCP using ODBC - problem with unique identifier

by: mpietrzyk | last post by:

Hi guys I'm having a nasty problem with bulk copying into a table that has unique identifier column. I'm coding on C++, using ODBC driver. I'm coping from a file containing UID description like this: {43B5B3DE-5280-4CBF-B357-D9E57651F0D1} (I also tried a non-bracket version) and in the DB table I get:

Microsoft SQL Server

15064

Maximum Function / Variable Name Identifier Length?

by: David T. Ashley | last post by:

I have this ugly habit of prefixing all function and variable names with some identifying information about the owning module and perhaps also the subcategory of function, i.e. CGIX_ARBINT_sqrt(); In a few cases, these names have become rather long. For both functions and variables, how long can I safely go without running into the...

C / C++

8766

Identifier Expected

by: jdziggy | last post by:

Hey all I am getting the compiler Identifier Expected on the following code. public partial class Form1 : Form { private const int MaxFiles = 10; private SourceFile m_sourceFiles(MaxFiles); private int m_files = 0; public Form1() {

C / C++

6603

illegal start of type and identifier error

by: dobbouk | last post by:

I'm getting these 2 errors and haven't got a clue whats causing them please java 43: illegal start of type for (i=0;i< Number_of_squares; i++) java 215 identifier expected } heres the whole code

Java

386

Function Identifier Not Found

by: kudruu | last post by:

Hi, I was trying to compile some code and I am getting a "Function identifier not found" error. I can't figure out why since the function that it claims is not identified is very clearly laid out. Here is the declaration in my h file: #pragma once #include "afxwin.h" class CGUIDlg : public CDialog {

C / C++

45008

error: expected identifier before ‘(’ token

by: nina01 | last post by:

Hi! I'm working on a mini compiler with flex and bison. The ".l" and ".y" files are generated successfully. However, when I try to compile the hole thing using the command "gcc -o comp comp.tab.c lex.yy.c ", I keep having this error :-( In file included from comp.l:4: comp.tab.h:56: error: expected identifier before ‘(’ token It's...

C / C++

7182

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7581

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7142

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7548

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5714

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

4773

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3259

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1624

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

488

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General