dbTalk Databases Forums  

Problem with public schema

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Problem with public schema in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Nick Allan
 
Posts: n/a

Default Problem with public schema - 05-19-2004 , 07:28 PM






Hi all
I've just started using postgres and have all my tables defined in the
public schema.
For some reason I'm being forced to use sql like the following
select * from public."tblCategory";
instead of
select * from tblCategory;

the
show search_path;
command returns
$user,public

When I use commands like
select * from tblCategory;
I get the following error

ERROR: Relation "tblcategory" does not exist





Anyone got any suggestions on what I'm missing here?



Nick Allan

Adaptive Technology Consultant

__________________________________________________ _

RVIB - VisTech

201 High Street, Prahran Vic 3181

Website: www.vistech.rvib.org.au

Email: nick.allan (AT) rvib (DOT) org.au
Phone: +613 9520 5555
Fax: +613 9525 2065

___________________________________________

This email (including all attachments) may contain personal information
and is intended solely for the named addressee. It is confidential and
may be subject
to legal or other professional privilege. Any confidentiality or
privilege is not waived or lost because this email has been sent to you
by mistake.
If you have received it in error, please let us know by reply email,
delete it from your system and destroy any copies.

This email is also subject to copyright. No part of it should be
reproduced, adapted or communicated without the written consent of the
copyright owner.
Any personal information in this email must be handled in accordance
with the Privacy Act 1988 (Cth).

Emails may be interfered with, may contain computer viruses or other
defects and may not be successfully replicated on other systems. We give
no warranties
in relation to these matters. If you have any doubts about the
authenticity of an email purportedly sent by us, please contact us
immediately.









Reply With Quote
  #2  
Old   
Manuel Sugawara
 
Posts: n/a

Default Re: Problem with public schema - 05-21-2004 , 10:05 AM






"Nick Allan" <allanni (AT) rvib (DOT) org.au> writes:

Quote:
I get the following error

ERROR:* Relation "tblcategory" does not exist

Anyone got any suggestions on what I'm missing here?
Try adding the quotes, like in public."tblCategory", for instance

SELECT * FROM "tblCategory"

Regards,
Manuel.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.