On Thu, 08 Feb 2001 15:19:16 Fred Schroeder wrote:
>I am having troubles getting started with a database, I have pgsql
>but can not seem to connect.
>I am running Linux Mandrake 7.2
>here is what I get from the command line:
>[fred(at)localhost fred]$ psql
>psql: FATAL 1: Database "fred" does not exist in the system catalog.
You can't create a database from within pgaccess. Create the database from
the command line:
bash# su postgres
bash$ createdb first
bash$ psql first
psql=> \i myscript.sql
Assumes "myscript.sql" contains DROP TABLE, CREATE TABLE, CREATE INDEX, and
GRANT/REVOKE commands. The SQL script can contain multiline comments in C++
/* This is a multiline comment.
It ends with the closing asterisk
or single line comments in SQL fashion:
-- This is a single line comment.
-- You can use several in a row, but
-- each one must begin with two dashes.
Both styles are acceptable to postgresql, and both are displayed as a
comments in my favorite editor, vim.
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>
In response to
pgsql-novice by date
|Next:||From: Geordie Hobart||Date: 2001-02-10 00:19:17|
|Subject: r-tree indexed searches|
|Previous:||From: Raymond Golish||Date: 2001-02-09 01:56:00|
|Subject: arrays of compound types|