RobR wrote > I selected the database in PGAdmin, went down to the Tables list (which > said I had 0 table), right clicked on the word "Tables", and selected "New > table". In the new table dialog I entered the table name as Log (no > quotes)
Enter the table name in lower-case. If you cannot surround your references to identifiers with double-quotes in your applications you must define all identifiers using lower-case only - so that after all identifiers in your application are converted to lower-case they will match up with those stored in PostgreSQL . PgAdmin issues its SQL in such a manner that what you enter is considered case-sensitive so you must do this manually if you rely on pgAdmin to perform your DDL. Note that all pgAdmin does is issue SQL against the database, and the SQL it issues indeed preserves case by putting identifiers in double-quotes. Those quotes, though, are strictly instructive to the parser of whether case is to be preserved. Any identifiers lacking quotes are automatically converted to lower-case first, and then that lower-case identifier is matched against the database in a literal fashion. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/PGAdmin-for-PostgreSQL-9-3-creates-tables-with-double-quotes-embedded-in-the-name-tp5805606p5805645.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com. -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
