Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
От | Rob Richardson |
---|---|
Тема | Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name |
Дата | |
Msg-id | 67D108EDFAD3C148A593E6ED7DCB4BBDD8468704@RADCONWIN2K8PDC.radcon.local обсуждение исходный текст |
Ответ на | Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name (Raymond O'Donnell <rod@iol.ie>) |
Ответы |
Re: PGAdmin for PostgreSQL 9.3 creates tables with
double quotes embedded in the name
Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name |
Список | pgadmin-support |
Thank you for your reply. You said, in part: What's happening in your case is that the table must have been created like this: create table "Log" [.....] But the whole point of my message is that that is not how this table was created. I did not open an SQL window and typein the CREATE TABLE command manually. I selected the database in PGAdmin, went down to the Tables list (which said Ihad 0 table), right clicked on the word "Tables", and selected "New table". In the new table dialog I entered the tablename as Log (no quotes), I defined its columns and its primary key, and I clicked OK. After I did all that, I thenfound that "select * from Log" (no quotes around Log) failed, claiming there was no relation named "Log". I then foundthat "select * from "Log" " (quotes around Log) worked. I then concluded that the table was being created with thedouble quotes included in the table name. I did find one place where I actually saw the name referred to as '"Log"'. That's the word Log, surrounded by double quotes,and then surrounded again by single quotes. Unfortunately, I do not now remember where that was. RobR
В списке pgadmin-support по дате отправления: