On Apr 20, 7:54 pm, Jorge Godoy <[EMAIL PROTECTED]> wrote: > It works. Are you sure you haven't used quotes and called your schema > "Cvt" or "CVT" or ... or even your table "Customers"? Remember that if > you omit quotes, PostgreSQL downcases names and if you use them it will > respect your will and make a case sensitive search for the object. > > Once you create something with quotes, you'll have to use them > everywhere, unless your name was all in lowercase...
Sorry if I'm failed to understand this. This is what I did:- clinic_live=# create table cvt.test (name varchar); CREATE TABLE clinic_live=# select * from "cvt.test"; ERROR: relation "cvt.test" does not exist clinic_live=# select * from cvt."test"; name ------ (0 rows) clinic_live=# select * from "cvt"."test"; name ------ (0 rows) clinic_live=# select * from cvt.test; name ------ (0 rows) 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". --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
