Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 08-28-2002, 01:09 AM   #1
Registered: Mar 2002
Location: ma
Distribution: slackware
Posts: 747

Rep: Reputation: 30
postgresql odd behavior

i have to enclose table user with " " but not for other tables..

this applies even in programs that access this database..

mydb=# \d
List of relations
Name | Type | Owner
category | table | postgres
category_id_seq | sequence | postgres
content | table | postgres
content_field | table | postgres
content_type | table | postgres
content_type_id_seq | sequence | postgres
object_id_seq | sequence | postgres
rating | table | postgres
relationship | table | postgres
relationship_type | table | postgres
user | table | postgres
(11 rows)

mydb=# select * from user;
ERROR: parser: parse error at or near "user"
ERROR: parser: parse error at or near "user"
mydb=# select * from rating;
relationship_id | rating
128 | 3
(1 row)

mydb=# select * from "user";
user_id | username | first_names | last_name | email | password

any idea?

k..... looks like 'user' is keyword of postgresql..
users works fine..

Last edited by doublefailure; 08-28-2002 at 01:17 AM.
Old 08-28-2002, 01:40 AM   #2
Senior Member
Registered: Jan 2002
Location: germany
Distribution: ubuntu
Posts: 1,507

Rep: Reputation: 128Reputation: 128
itīs like that, a reserved one:
cheers, jens


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Odd Knoppix behavior Darkstar Linux - Distributions 1 06-25-2005 10:46 PM
Odd RedHat 9.0 behavior... 386 Linux - Networking 2 10-15-2004 11:00 AM
Odd Behavior of Epiphany Jeffmrg Slackware 2 09-09-2004 09:23 AM
Odd Re-Booting Behavior ....... ? justaguynsrq Slackware 2 04-16-2004 01:02 PM
RH 6.2 ... odd behavior jubal Linux - Networking 3 02-27-2001 10:04 AM

All times are GMT -5. The time now is 07:15 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration