pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

ECPG and Table/Field name case sensitivity
2+ messages / 1 participants
[nested] [flat]

* ECPG and Table/Field name case sensitivity
@ 1999-09-30 21:08 Dana L. Hones <honesd@ix.netcom.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Dana L. Hones @ 1999-09-30 21:08 UTC (permalink / raw)
  To: pgsql-interfaces

Hello,

I have a PostgreSQL DB on Linux that I copied over from MS Access.  Thus, I 
have mixed case table and field names.  I can access the database from PSQL 
in the following manner:

	select * from "Namelist" where "NameID" = 1234;

How may I accomplish the same thing while using ECPG under C?  ECPG ignores 
the quotes and converts the table and field names to lower case.  I tried 
editing the output "C" file from ECPG and now the C complier complains 
about the syntax.

Any help would be greatly appreciated.

DLH

Dana L. Hones
Hones MacDonald, Inc.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* ECPG and Table/Field name case sensitivity
@ 1999-09-30 21:53 Dana L. Hones <honesd@ix.netcom.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Dana L. Hones @ 1999-09-30 21:53 UTC (permalink / raw)
  To: pgsql-interfaces

Hello,

I have a PostgreSQL DB on Linux that I copied over from MS Access.  Thus, I 
have mixed case table and field names.  I can access the database from PSQL 
in the following manner:

	select * from "Namelist" where "NameID" = 1234;

How may I accomplish the same thing while using ECPG under C?  ECPG ignores 
the quotes and converts the table and field names to lower case.  I tried 
editing the output "C" file from ECPG and now the C compiler complains 
about the syntax.

Any help would be greatly appreciated.

DLH

Dana L. Hones
Hones MacDonald, Inc.




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~1999-09-30 21:53 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-30 21:08 ECPG and Table/Field name case sensitivity Dana L. Hones <honesd@ix.netcom.com>
1999-09-30 21:53 ECPG and Table/Field name case sensitivity Dana L. Hones <honesd@ix.netcom.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox