On Jun 23, 2007, at 21:29 , Naz Gassiep wrote:
Is there a limit on the length of table names?
NAMEDATALEN
http://www.postgresql.org/docs/8.2/interactive/sql-syntax-
lexical.html#SQL-SYNTAX-IDENTIFIERS
Michael Glaesemann
grzm seespotcode net
---(end of broadcast)
Is there a limit on the length of table names?
Thanks,
- Naz.
---(end of broadcast)---
TIP 6: explain analyze is your friend
> We have recently had a few problems with Interbase on Linux so the
> pressure is on them (and they are defiantely not moving ahead as fast as
> postgresql is, all the recent versions have been very late and some big
> bugs have been left in the field for a long time).
Yes, we seem to move at li
> That explains it. In fact, the creates do not use double quotes,
> but the queries do. I'll have to find a way to fix that.
I have seen that before. Quotations either preserve case, or they
don't, but it seems some db's don't honor that.
--
Bruce Momjian| http://w
Stephen,
Interesting that you are converting from Interbase. We have now reached
the point where we only use 2 commercial pieces of software. Interbase
and Visual SlickEdit. I would like to drop Interbase but currently we
ship quite a few single user systems running on Win 9x.
We have very good
That explains it. In fact, the creates do not use double quotes, but the queries
do. I'll have to find a way to fix that.
Steve
>
> All identifiers are changed to lower case unless they are in
> double-quotes. If they use double-quotes in the creates, but not in the
> queries, you will have
> Try exporting the tables (including table creation stmts) to a text file and
> then ASCII ftping the file to the Unix Server to convert the CRLF and import
> using pgsql...The documentation has the commands to import files...
>
All identifiers are changed to lower case unless they are in
doub
gt;
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 24, 1999 11:47 PM
Subject: [GENERAL] Table names case sensitive?
> Although the PostgreSQL tables are created correctly, the write
> operations are failing. It looks like the ODBC driver is attempting to
> create tables with
Having been suitable impressed by the "PostgreSQL ready for mission
critical apps" thread, I decided to bite the bullet and convert our
database from Interbase to PostgreSQL. Almost immediately I encountered
a puzzling problem. To make things easy, I am using the Borland "data
pump" on an NT mac
Is there any way to use table names longer than 32 characters
Dale.
10 matches
Mail list logo
