G.Schaeffler wrote:
> if i create a table by using the pgadmin gui, it will create statements
> like
> CREATE TABLE "t_test" (
> id integer,
> "val" character varying(1000) NOT NULL );
> after creation, i can only access the table again if i wrap the apostrophes
> around the table and field names as in the create table statement.
Does your table name have uppercase chars? If it has, that's probably
the reason the name doesn't work unless quoted. This is expected
behavior for identifiers.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support