Re: ERROR: relation "default_cols" does not exist
От | David Sadler |
---|---|
Тема | Re: ERROR: relation "default_cols" does not exist |
Дата | |
Msg-id | 000f01c563b1$3741af60$6501a8c0@TRUCK обсуждение исходный текст |
Ответ на | ERROR: relation "default_cols" does not exist ("David Sadler" <david@dicapp.com>) |
Ответы |
Re: ERROR: relation "default_cols" does not exist
(John DeSoi <desoi@pgedit.com>)
|
Список | pgsql-novice |
Hello, John, Thanks for your help. dss: How do I logon directly to the test db using psql.exe without modifying its target path? js: One option is to navigate to the postgresql bin directory and then enter the psql command. Another is to add the bin directory to your PATH variable. John, is the psql.exe like sql*plus in oracle? Am I logging on to the server when it presents the password prompt, and then from there, I connect to whatever db I specify? ... dss: Why am I not able to select from the test db table I created? Instead, I get... ERROR: relation "default_cols" does not exist? js: Connect via psql and enter the command \dt to see a list of tables in the database. If it does not answer your question, show the output with the error and ask again. dss: Results of \dt against testdb "gov"... <<< List of relations Schema = public name = DEFAULT_COLS type = table owner = postgres (1 row) >>> dss: Result of select * from default_cols; <<< ERROR: relation "default_cols" does not exist >>> dss: Upon launching psql to gov shortcut, this warning is presented... <<< Warning: Console code page (437) differs from Window code page (1252) 8-bit characters may not work correctly. See psql reference page "Notes for Windows users" for details. >>> "Notes for Windows users" was not found in the installed doc. I did find it in the more robust doc here. "comprehensive manual" http://www.postgresql.org/files/documentation/pdf/8.0/postgresql-8.0-US.pdf dss: It reads... <<< Notes for Windows users psql is built as a "console application". Since the Windows console windows use a different encoding than the rest of the system, you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it will warn you at startup. To change the console code page, two things are necessary: Set the code page by entering cmd.exe /c chcp 1252. (1252 is a code page that is appropriate for German; replace it with your value.) If you are using Cygwin, you can put this command in /etc/profile. Set the console font to "Lucida Console", because the raster font does not work with the ANSI code page. >>> dss: I'm looking for cmd.exe /c chcp [code] for English. Any thoughts on the "relation "default_cols" does not exist error now? Thanks, David Sadler ref: (1) ----- Original Message ----- From: "John DeSoi" <desoi@pgedit.com> To: "David Sadler" <david@dicapp.com> Cc: "pgsql-novice" <pgsql-novice@postgresql.org> Sent: Wednesday, May 25, 2005 11:19 PM Subject: Re: [NOVICE] ERROR: relation "default_cols" does not exist > John DeSoi, Ph.D. > http://pgedit.com/ > Power Tools for PostgreSQL
В списке pgsql-novice по дате отправления: