Re: ERROR: relation "default_cols" does not exist - Mailing list pgsql-novice

From John DeSoi
Subject Re: ERROR: relation "default_cols" does not exist
Date
Msg-id 5d40dea45a9537b0cf4b1d8a2dca02cf@pgedit.com
Whole thread Raw
In response to ERROR: relation "default_cols" does not exist  ("David Sadler" <david@dicapp.com>)
List pgsql-novice
David,

On May 26, 2005, at 1:21 PM, David Sadler wrote:

>
> Where did the service install actally place the pgsql data folder that
> is holding the created databases?

The default is C:\Program Files\PostgreSQL\8.0\data

> How do I logon directly to the test db using psql.exe without
> modifying its target path?

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.

> Why am I not able to select from the test db table I created with
> getting the
>  ERROR: relation "default_cols" does not exist?

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.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to Delete a Row
Next
From:
Date:
Subject: Carriage Returns Disappearing