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
)file only, from the PgAccess web site. <br /><u>My question is, in which directory do you put the ( formdemo.sql )
databasefile in.</u><br />So when you type <br /># su - roland <br />$ createdb formdemo <br />$ psql formdemo
<formdemo.sql<br />I get <br />bash: formdemo.sql: No such file or directory <br />~~~~~~~~~ <br />I do get when I
type<br />$ psql formdemo <br />Welcome etc. <br />formdemo=> \d <br />Then I get a table <br />~~~~~~ <br />The
formdemo.sqldoes not show up in PgAccess <br />I have other databases, tables and forms working in PgAccess? <br
/>Thanks,Roland <p><u>Constantin Teodorescu wrote:</u><p>Let's say you are the Linux user roland on your computer.
<p>Thereis a postgres user , the master of PostgreSQL database server as <br />the system administrator. <br />Don't
knowthe password for postgres user but you should assign one as <br />root and then log in as postgres user. <br />Then
createa PostgreSQL user with the following command: <p>$ createuser roland <p>and follow the instructions there. Now
youhave a PostgreSQL user roland <br />and you may create databases , other users and so on. <p>As postgres linux user
(oras 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>Thenrun PgAccess as : <p>$ pgaccess formdemo <p>or simply run PgAccess without parameter and the from the
Database/Open<br />menu, specify formdemo as your database, localhost to host, 5432 as <br />port. Username and
passwordmay not be supplied if you are connecting to <br />localhost. <p>Enjoy, <br />-- <br />Constantin Teodorescu
<br/>FLEX Consulting Braila, ROMANIA <p><u>Roland N Verrier wrote:</u><p>Question for the Masters <br />This maybe a
simplequestion, but how do you activate the sample demo, formdemo.sql in PgAccess. <p>~~~~~~ <br />I have install on my
Linuxmachine, <br />Red Hat 6.0 <br />PostgreSQL v 6.4.2-6 <br />PgAccess v 0.98, nice improvement <br />~~~~~~ <br
/>Postmasterrunning, PgAccesss running <br />PgAccess v 0.98 is in /usr/local/pgaccess <br />Off the Web site it says,
Createan empty database and psql your database <formdemo.sql <br />I have the template1 and other databases in
/var/lib/pgsql/base<br />How do I make the connection with formdemo.sql and the base dir., if I create a new database,
<br/>opened in PgAccess? <br />~~~~~~ <br />Thanks, for Being Creators and Helpers ************