Re: [INTERFACES] PGACCESS formdemo.sql

Help <br />Concerning the the sample formdemo, ( formdemo.sql ) <br />This demo file is in the (
/usr/local/pgaccess/demo/formdemo.sql) directory, from the upgrade v 0.98. <br />Or you can download the ( formdemo.sql
)<u>file only</u>, from the PgAccess web site. <br />My question is, which directory do you put the ( formdemo.sql )
file.<br />So when you type <br />$ createdb formdemo <br />$ psql formdemo <formdemo.sql <br />I get no such file
ordirectory <br />Thanks, Roland <br />  <br />  <blockquote type="CITE">Roland N Verrier wrote: <br />> <br />>
Postmasterrunning, PgAccesss running <br />> PgAccess v 0.98 is in /usr/local/pgaccess <br />> Off the Web site
itsays, Create an empty database and psql your <br />> database <formdemo.sql <br />> I have the template1 and
otherdatabases in /var/lib/pgsql/base <br />> How do I make the connection with formdemo.sql and the base dir., if I
<br/>> create a new database, opened in PgAccess?</blockquote><blockquote type="CITE">Constantin Teodorescu wrote:
<p>Let'ssay you are the Linux user roland on your computer. <p>There is a postgres user , the master of PostgreSQL
databaseserver as <br />the system administrator. <br />Don't know the password for postgres user but you should assign
oneas <br />root and then log in as postgres user. <br />Then create a PostgreSQL user with the following command: <p>$
createuserroland <p>and follow the instructions there. Now you have a PostgreSQL user roland <br />and you may create
databases, other users and so on. <p>As postgres linux user (or as roland) create and fill the formdemo <br />database
:<p>$ createdb formdemo <br />$ psql formdemo <formdemo.sql <p>Now database formdemo should exist, check it with :
<p>$psql formdemo <br />formdemo=> \d <p>Then run PgAccess as : <p>$ pgaccess formdemo <p>or simply run PgAccess
withoutparameter and the from the Database/Open <br />menu, specify formdemo as your database, localhost to host, 5432
as<br />port. Username and password may not be supplied if you are connecting to <br />localhost. <p>Enjoy, <br />--
<br/>Constantin Teodorescu <br />FLEX Consulting Braila, ROMANIA</blockquote>