Hi
I have the following columns in my input file which is sorted on ColA
colA colB colC colD colE
The data is such that for a single colA it can have multiple values of other columns, for eg the data can be
colA colB colC ... (1 Reply)
Hi guys--
Here is the interesting problem..
I have a folder, which has a couple of xml files like ( could be anywhere under the sub folders)
ABCD_NA.xml
XAYSGD_SC.xml
CBV_CA.xml
etc
I need to peek in each of these xml's and see that the pattern before the _ and after the _ are there... (0 Replies)
i need to search the starting line
example we have
-sh
shl-js-gd
i need to search only starting -sh not the other
i have used cmd
cat filename | grep '-'
but it will check for complete - in the file
please help me to search only starting -
thank u
revenna (0 Replies)
Hi all,
I'm a newbie. I'm thinking of making a shell script which will list a directory for *.csv files and merge all the files into a single file called data.csv.
However, i have no idea how to. What i do currently is to manually issue the following command to merge multiple CSV files into... (1 Reply)
i am trying to read an existing xml file and find an element in the xml file of following format
<home.dir value="/local/mnt/homes/docs"/>
I am trying to take a command line argument to my shell script whose value should replace /local/mnt/homes/docs in xml document.
Can you please point me how... (3 Replies)
Hi all,
I need to modify the below highlighted piece to perform the below task. Please let me know as i am not able to figure out a way to do this.
|| FILENAME=$(date +"$FILENAME")
if ; then
do_log FATAL "FILENAME needs to be set if SWITCH2=0"
exit 1
fi... (3 Replies)
#!/bin/sh
#Displaying every argument
while ;
do
echo Moving file $0;
shift;
done
exit 0;
For the above script i get the below o/p when 2 arguments are passed when invoking the script
dmlFileCopy.sh: line 3:
Can you let me know how to rectify the error? (2 Replies)
Hi I want a script which should basically do
1. If the size of the file is 0kb,
send email to some list od ppl
2. if the size of the file is other than 0kb
send email to someother list...
Pls help (2 Replies)
Hi,
I have trouble building the logic for the following, could anyone please help me out with this:
Im working on a wrapper script to check for input files (in a specific directory) and pass
the input files along with the options as parameters to the main script.The options vary depending ... (2 Replies)
I want to take out the Z1 value from the lscfg outpu and use the below command to get it
lscfg -vl hdisk0 | grep "Device Specific.(Z1)" | awk -F. '{print $NF}'
# lscfg -vpl hdisk0
.
.
Device Specific.(Z0)........0000063268181002
Device Specific.(Z1)........020064a
.
And it works,... (2 Replies)
Discussion started by: moorthikv
2 Replies
LEARN ABOUT CENTOS
create_foreign_table
CREATE FOREIGN TABLE(7) PostgreSQL 9.2.7 Documentation CREATE FOREIGN TABLE(7)NAME
CREATE_FOREIGN_TABLE - define a new foreign table
SYNOPSIS
CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [
{ column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ NULL | NOT NULL ] }
[, ... ]
] )
SERVER server_name
[ OPTIONS ( option 'value' [, ... ] ) ]
DESCRIPTION
CREATE FOREIGN TABLE will create a new foreign table in the current database. The table will be owned by the user issuing the command.
If a schema name is given (for example, CREATE FOREIGN TABLE myschema.mytable ...) then the table is created in the specified schema.
Otherwise it is created in the current schema. The name of the foreign table must be distinct from the name of any other foreign table,
table, sequence, index, or view in the same schema.
CREATE FOREIGN TABLE also automatically creates a data type that represents the composite type corresponding to one row of the foreign
table. Therefore, foreign tables cannot have the same name as any existing data type in the same schema.
To be able to create a table, you must have USAGE privilege on all column types.
PARAMETERS
IF NOT EXISTS
Do not throw an error if a relation with the same name already exists. A notice is issued in this case. Note that there is no guarantee
that the existing relation is anything like the one that would have been created.
table_name
The name (optionally schema-qualified) of the table to be created.
column_name
The name of a column to be created in the new table.
data_type
The data type of the column. This can include array specifiers. For more information on the data types supported by PostgreSQL, refer
to Chapter 8, Data Types, in the documentation.
NOT NULL
The column is not allowed to contain null values.
NULL
The column is allowed to contain null values. This is the default.
This clause is only provided for compatibility with non-standard SQL databases. Its use is discouraged in new applications.
server_name
The name of an existing server for the foreign table.
OPTIONS ( option 'value' [, ...] )
Options to be associated with the new foreign table or one of its columns. The allowed option names and values are specific to each
foreign data wrapper and are validated using the foreign-data wrapper's validator function. Duplicate option names are not allowed
(although it's OK for a table option and a column option to have the same name).
EXAMPLES
Create foreign table films with film_server:
CREATE FOREIGN TABLE films (
code char(5) NOT NULL,
title varchar(40) NOT NULL,
did integer NOT NULL,
date_prod date,
kind varchar(10),
len interval hour to minute
)
SERVER film_server;
COMPATIBILITY
The CREATE FOREIGN TABLE command largely conforms to the SQL standard; however, much as with CREATE TABLE, NULL constraints and zero-column
foreign tables are permitted.
SEE ALSO
ALTER FOREIGN TABLE (ALTER_FOREIGN_TABLE(7)), DROP FOREIGN TABLE (DROP_FOREIGN_TABLE(7)), CREATE TABLE (CREATE_TABLE(7)), CREATE SERVER
(CREATE_SERVER(7))
PostgreSQL 9.2.7 2014-02-17 CREATE FOREIGN TABLE(7)