GUI tools for Posgresql and database files

From: Raigo77(at)solo(dot)delfi(dot)ee (Raigo)
To: pgsql-novice(at)postgresql(dot)org
Subject: GUI tools for Posgresql and database files
Date: 2003-08-18 20:32:13
Message-ID: 80df3db1.0308181232.24e7d713@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am using PostgreSQL 7.3.2 which I installed with default options
with Mandrake 9.1, at the moment for learning. I am now using tool
named PSQL for creating tables, views etc. But I read about tool named
PGACCESS which is GUI. My question: is this installed somewhere by
default? if yes how to run it?

my second question: where does PostgreSQL 7.3.2 put it's physical
database files? In Interbase I just need to copy *.gdb files if I move
from one machine to another. I read in Postgres there is a directory
for each database for example database mydb is in
/usr/local/pgsql/database/mydb which holds one database. But in my
installation I don't have that directory. I did search with mydb name,
but it did not find anything. where to look and which files are needed
if I want to move databases?

thanks for ideas.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-08-18 20:55:29 Re: Nie ma mnie w biurze
Previous Message icaplovic 2003-08-18 20:02:09 Ivan Čaplovič je na dovolenke.