Securing-Optimizing-RH-Linux-1_2_338
Comments and suggestions concerning this book should be mailed to gmourani@videotron.ca
© Copyright 1999-2000 Gerhard Mourani and Open Network Architecture ®
338
template1e create database foo;
CREATEDB
NOTE: Client connections can be restricted by IP address and/or user name via the
pg_hba.conf file in PG_DATA.
Other useful Postgres terminal monitor program (psql) are:
·
To connect to the new database, use the command:
template1e \c foo
connecting to new database: foo
fooe
·
To create a table, use the command:
fooe create table bar (i int4, c char(16));
CREATE
fooe
·
To inspect the new table, use the command:
fooe \d bar
Table = bar
+----------------------------------+----------------------------------+------------+
| Field
| Type
| Length |
+----------------------------------+----------------------------------+------------+
| I
| int4
| 4 |
| c
| char()
| 16 |
+----------------------------------+----------------------------------+------------+
fooe
·
To drop a table, index, view, use the command:
fooe drop table table_name;
fooe drop index index_name;
fooe drop view view_name;
·
To insert into: (once a table is created, it can be filled using the command
)
fooe insert into table_name (name_of_attr1, name_of_attr2, name_of_attr3)
fooe values (value1, value2, value3);
Installed files
> /etc/rc.d/init.d/postgresql
> /etc/rc.d/rc0.d/K15postgresql
> /etc/rc.d/rc1.d/K15postgresql
> /etc/rc.d/rc2.d/K15postgresql
> /etc/rc.d/rc3.d/S85postgresql
> /etc/rc.d/rc4.d/S85postgresql
> /etc/rc.d/rc5.d/S85postgresql
> /etc/rc.d/rc6.d/K15postgresql
> /usr/bin/postgres
> /usr/bin/postmaster
> /usr/bin/ecpg
> /usr/bin/pg_id
> /usr/bin/pg_version
> /usr/bin/psql
> /usr/bin/pg_dump
> /usr/bin/pg_dumpall
> /usr/bin/pg_upgrade
> /usr/bin/pg_passwd
> /usr/bin/cleardbdir
> /usr/man/manl/begin.l
> /usr/man/manl/close.l
> /usr/man/manl/cluster.l
> /usr/man/manl/commit.l
> /usr/man/manl/copy.l
> /usr/man/manl/create_aggregate.l
> /usr/man/manl/create_database.l
> /usr/man/manl/create_function.l
> /usr/man/manl/create_index.l
> /usr/man/manl/create_language.l
> /usr/man/manl/create_operator.l
> /usr/man/manl/create_rule.l
> /usr/man/manl/create_sequence.l
> /usr/man/manl/create_table.l
> /usr/man/manl/create_trigger.l
> /usr/man/manl/create_type.l
> /usr/man/manl/create_user.l
> /usr/man/manl/create_version.l
> /usr/man/manl/create_view.l