I need to put together a script that will take the contents of two different files (database name and database owner) and put them in two variables within a line:
Running the above only gives me the first database name on every line with the owner for all of the other databases as the second parameter. I need a line for each database name/dba combination.
Hello, I am new at this forum so please bare with me on this.
Within a given directory, I have a list of files in which in each file, I would like to do a substitution. I would like to substitute the string mlcl to mll in each file using the foreach command. I dont quite get how to do that. If... (7 Replies)
Hi Guys,
I have a loop which uses a wildcard
i.e. foreach f (*)
but when I execute the tcsh file in unix then it gives me an error
->>>>>>>foreach: words not parenthesized<<<<<<<<<<-
Any help. (1 Reply)
In a foreach loop, is it possible for the loop to go through 2 arguments instead of one
i.e. instead of foreach i (do stuff for i), we have foreach i j(do stuff for i; do stuff for j)
I am working under BASH and TCSH shell environments
cheers (3 Replies)
Hi everyone
Does anyone know what is wrong with this script. i keep getting errors
foreach filename (`cat testing1`)
set string=$filename
set depth=`echo "$string"
echo $depth
end
the error is the following
testing: line 1: syntax error near unexpected token `('
testing: line 1:... (3 Replies)
Hi All,
Is there any problem with the below 'foreach' loop?
foreach risk_factor ($(cat "$rf_list"))
where "rf_list=$SCRIPT/Utility/rflist.txt "
I'm wondering, it is throwing below error message:
syntax error at line 34: `(' unexpected
Any idea/suggestions ?
Thanks in advance /... (7 Replies)
So I am back again beating my head against the wall with a shell script and getting a headache! I want to change each year in a file (1980, 1981, 1982, 1983, etc.) to the same year followed by a tab.
The input is "blah blah (1980) blah blah".
I want to get "blah blah (1980 ) blah blah".... (2 Replies)
I am trying to make a script for my Counter-Strike: Source servers. What i am wanting it to do is for it to restart each server, the only way i can think of doing this in through for each.
Years what i have at the moment.
server_start() {
START=`ps x | grep SCREEN | grep $SRV | cut -d '?' -f... (5 Replies)
Dear all,
I wrote a script to download files and move files in directories according to their name.
Now here is the problem:
Both p101 and p360 data download successfully, but when I move them according to the year and month, only p101 data can be placed at the right location, p360,... (1 Reply)
Hi everyone I'm new to unix and encountered a small problem i couldnt find out a reason why it doesn't work..please help..
in my csh script when i tried to use the foreach loop like this:
foreach x ( ls )
echo $x
end
when i tried to run it, it printed out 'ls' to the std out instead of... (3 Replies)
Discussion started by: ymc1g11
3 Replies
LEARN ABOUT REDHAT
createdb
CREATEDB(1) PostgreSQL Client Applications CREATEDB(1)NAME
createdb - create a new PostgreSQL database
SYNOPSIS
createdb [ options... ] [ dbname ] [ description ]
DESCRIPTION
createdb creates a new PostgreSQL database.
Normally, the database user who executes this command becomes the owner of the new database. However a different owner can be specified
via the -O option, if the executing user has appropriate privileges.
createdb is a shell script wrapper around the SQL command CREATE DATABASE [create_database(7)] via the PostgreSQL interactive terminal
psql(1). Thus, there is nothing special about creating databases via this or other methods. This means that the psql program must be found
by the script and that a database server must be running at the targeted port. Also, any default settings and environment variables avail-
able to psql and the libpq front-end library will apply.
OPTIONS
createdb accepts the following command-line arguments:
dbname Specifies the name of the database to be created. The name must be unique among all PostgreSQL databases in this installation. The
default is to create a database with the same name as the current system user.
description
This optionally specifies a comment to be associated with the newly created database.
-D location
--location location
Specifies the alternative location for the database. See also initlocation(1).
-e
--echo Echo the queries that createdb generates and sends to the server.
-E encoding
--encoding encoding
Specifies the character encoding scheme to be used in this database.
-O owner
--owner owner
Specifies the database user who will own the new database.
-q
--quiet
Do not display a response.
-T template
--template template
Specifies the template database from which to build this database.
The options -D, -E, -O, and -T correspond to options of the underlying SQL command CREATE DATABASE [create_database(7)]; see there for more
information about them.
createdb also accepts the following command-line arguments for connection parameters:
-h host
--host host
Specifies the host name of the machine on which the server is running. If host begins with a slash, it is used as the directory for
the Unix domain socket.
-p port
--port port
Specifies the Internet TCP/IP port or the local Unix domain socket file extension on which the server is listening for connections.
-U username
--username username
User name to connect as
-W
--password
Force password prompt.
DIAGNOSTICS
CREATE DATABASE
The database was successfully created.
createdb: Database creation failed.
(Says it all.)
createdb: Comment creation failed. (Database was created.)
The comment/description for the database could not be created. The database itself will have been created already. You can use the
SQL command COMMENT ON DATABASE to create the comment later on.
If there is an error condition, the backend error message will be displayed. See CREATE DATABASE [create_database(7)] and psql(1) for pos-
sibilities.
ENVIRONMENT
PGDATABASE
If set, the name of the database to create, unless overridden on the command line.
PGHOST
PGPORT
PGUSER Default connection parameters. PGUSER also determines the name of the database to create, if it is not specified on the command line
or by PGDATABASE.
EXAMPLES
To create the database demo using the default database server:
$ createdb demo
CREATE DATABASE
The response is the same as you would have gotten from running the CREATE DATABASE SQL command.
To create the database demo using the server on host eden, port 5000, using the LATIN1 encoding scheme with a look at the underlying query:
$ createdb -p 5000 -h eden -E LATIN1 -e demo
CREATE DATABASE "demo" WITH ENCODING = 'LATIN1'
CREATE DATABASE
SEE ALSO dropdb(1), CREATE DATABASE [create_database(7)]
Application 2002-11-22 CREATEDB(1)