Re: [GENERAL] table name restiction

2005-01-31 Thread Richard Huxton
dale wrote: PostgreSQL users, What are the restrictions on naming tables or columns in tables other than uniqueness (assuming ascii characters)? For instance, are names case sensitive. What special characters can be used (`_`,`-`,` `). I looked at the docs in the tutorial part in the

Re: [GENERAL] table name restiction

2005-01-31 Thread Michael Fuhr
On Mon, Jan 31, 2005 at 03:05:52PM -0600, dale wrote: > > What are the restrictions on naming tables or columns in tables > other than uniqueness (assuming ascii characters)? See "Identifiers and Key Words" in the "SQL Syntax" chapter of the documentation: http://www.postgresql.org/docs/8.0/stat

Re: [GENERAL] table name restiction

2005-01-31 Thread Mike Nolan
> I looked at the docs in the tutorial part in the beginning and in the > description of CREATE TABLE but could not find naming restriction info. > Could someone point me in the right direction? Try section 4.1.1: Identifiers and Key Words. In general PostgreSQL's SQL syntax is case-insens

[GENERAL] table name restiction

2005-01-31 Thread dale
PostgreSQL users, What are the restrictions on naming tables or columns in tables other than uniqueness (assuming ascii characters)? For instance, are names case sensitive. What special characters can be used (`_`,`-`,` `). I looked at the docs in the tutorial part in the beginning and i