Re: [GENERAL] ERROR: relation table does not exist - HELP
That happens when you type: \d From the PSQL sql prompt, like this: connxetl=# \d List of relations Name | Type | Owner ---+--+-- ActiveRange | table | datasync ActiveRangeSequence | sequence | datasync AndScheduleStoplight | table | datasync AndTaskStoplight | table | datasync AssemblyDomain | table | datasync AssemblyGroup | table | datasync AssemblyParentTableGroups | table | datasync AssemblyParentTasks | table | datasync AssemblyProgress | table | datasync AssemblyTasks | table | datasync EmailDomain | table | datasync EmailDomainSequence | sequence | datasync ErrorStatusDictionary | table | datasync Frequency | table | datasync GlobalUniqueSequence | sequence | datasync GroupProgress | table | datasync Groups | table | datasync GroupsSequence | sequence | datasync GuiObjectInfo | table | datasync IntervalFilter | table | datasync IntervalFilterSequence | sequence | datasync IntervalType | table | datasync IntervalTypeSequence | sequence | datasync OfThe | table | datasync OfTheSequenceMUID | sequence | datasync OfTheSequenceSUID | sequence | datasync OrScheduleStoplight | table | datasync OrTaskStoplight | table | datasync ParentAssemblies | table | datasync ParentTableGroups | table | datasync ParentTasks | table | datasync Periods | table | datasync PeriodsSequence | sequence | datasync PriorityDomain | table | datasync PriorityDomainSequence | sequence | datasync Schedule | table | datasync ScheduleSequence | sequence | datasync ScheduleTrigger | table | datasync SourceAssemblyTables | table | datasync SourceTaskTables | table | datasync StartTime | table | datasync StartTimeSequence | sequence | datasync StatusDomain | table | datasync TableCollection | table | datasync TableGroup | table | datasync TableGroupParentAssemblies | table | datasync TableGroupParentTasks | table | datasync TableList | table | datasync TableListSequence | sequence | datasync TableParentAssemblies | table | datasync TableParentTasks | table | datasync TableProgress | table | datasync TargetAssemblyTables | table | datasync TargetTaskTables | table | datasync TaskGroup | table | datasync TaskParentAssemblies | table | datasync TaskParentTables | table | datasync TaskProgress | table | datasync TaskTypeDomain | table | datasync Tasks | table | datasync TimeoutUnits | table | datasync TimeoutUnitsSequence | sequence | datasync WorkflowSettings | table | datasync WorkflowSettingsSequence | sequence | datasync XorScheduleStoplight | table | datasync XorTaskStoplight | table | datasync From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of itamar Sent: Friday, December 10, 2004 7:54 PM To: [EMAIL PROTECTED] Subject: [GENERAL] ERROR: relation table does not exist - HELP when I run select * from table I get this error. ERROR: relation table does not exist Itamar Reis Peixoto +55 34 3238 3845 +55 38 9107 1250 http://www.ispbrasil.com.br
Re: [GENERAL] ERROR: relation table does not exist - HELP
On Sat, 2004-12-11 at 01:54 -0200, itamar wrote: when I run select * from table I get this error. ERROR: relation table does not exist The table name is is folded to lowercase, unless it is in quotes. so if the name of the table is TABLE, you need select * from TABLE Is this your problem ? gnari ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[GENERAL] ERROR: relation table does not exist - HELP
when I run select * from "table" I get this error. ERROR: relation "table" does not exist Itamar Reis Peixoto+55 34 3238 3845+55 38 9107 1250http://www.ispbrasil.com.br No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org