k4ml <[EMAIL PROTECTED]> writes: > So it look's like postgresql only allow the indentifier to be in form > of schema.table, schema."table" or "schema"."table" but elixir seem's > to put it as "schema.table".
I know I've used Elixir against some of my tables before going back to pure SA... "schema.table" means a table named "schema.table", not a table named "table" inside a schema named "schema". Quotes are also used to specify special characters in column and table names (such as "My Table" or "My Column" -- with a space in their names). Elixir shouldn't use quotes at all when issuing SQL commands (or it should use the exactly same convention it used to create tables -- and I'm supposing here that you have created your tables with it, otherwise it might be doing the right thing ;-)). I suspect Elixir works... But I don't have any remaining code to check it :-( -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
