By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

Max length name of a database/schema

P: n/a
Did you know what is the maximum character length for a name of :
a database or schema ?
a table or a view ?
a column ?
a constraint ?
an index ?
thanks
--
Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
Le site du SQL, pour débutants et pros : http://sqlpro.developpez.com
************************ www.datasapiens.com *************************

Nov 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
All the same, there is only one "identifier" type.

It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.

On Fri, Oct 29, 2004 at 01:49:23PM +0200, Fred BROUARD - SQLpro wrote:
Did you know what is the maximum character length for a name of :
a database or schema ?
a table or a view ?
a column ?
a constraint ?
an index ?
thanks
--
Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
Le site du SQL, pour débutants et pros : http://sqlpro.developpez.com
************************ www.datasapiens.com *************************


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBhf/LY5Twig3Ge+YRAoN3AJ4rTl3mzmhCK6wdxXLCVTvyLW3LtgCeO BWy
w7yaHfyDPsrZcsC3T3pelb4=
=CbxS
-----END PGP SIGNATURE-----

Nov 23 '05 #2

P: n/a
On Mon, 1 Nov 2004 10:20:14 +0100, Martijn van Oosterhout
<kl*****@svana.org> wrote:
All the same, there is only one "identifier" type.

It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.


It's been 63 characters since 7.2 or 7.3. See
src/include/postgres_ext.h and look for NAMEDATALEN.

Ian Barwick
ba*****@gmail.com

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

Nov 23 '05 #3

P: n/a
All the same, there is only one "identifier" type.

It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.

On Fri, Oct 29, 2004 at 01:49:23PM +0200, Fred BROUARD - SQLpro wrote:
Did you know what is the maximum character length for a name of :
a database or schema ?
a table or a view ?
a column ?
a constraint ?
an index ?
thanks
--
Frédéric BROUARD, MVP SQL Server. Expert SQL / spécialiste Delphi, web
Livre SQL - col. Référence : http://sqlpro.developpez.com/bookSQL.html
Le site du SQL, pour débutants et pros : http://sqlpro.developpez.com
************************ www.datasapiens.com *************************


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFBhf/LY5Twig3Ge+YRAoN3AJ4rTl3mzmhCK6wdxXLCVTvyLW3LtgCeO BWy
w7yaHfyDPsrZcsC3T3pelb4=
=CbxS
-----END PGP SIGNATURE-----

Nov 23 '05 #4

P: n/a
On Mon, 1 Nov 2004 10:20:14 +0100, Martijn van Oosterhout
<kl*****@svana.org> wrote:
All the same, there is only one "identifier" type.

It got bigger recently, but it's either 31 or 63 characters... Look
through the documentation.


It's been 63 characters since 7.2 or 7.3. See
src/include/postgres_ext.h and look for NAMEDATALEN.

Ian Barwick
ba*****@gmail.com

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

Nov 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.