Wildman <[email protected]> writes: > Thanks, Rick -- that is indeed quite helpful. > > I am a bit unsure of how to specify the table name so that it retains > lower-case. If I quote the name when creating the table; e.g. "create table > 'part_type' ( .... )" then I get a SQL error complaining about the quotes. > Is there another way to specify a table name including casing?
Hi Bill, You need to use double-quotes for SQL identifiers (single-quotes are only for string literals): create table "part_type" ( .... ) -- Knut Anders
