Hello All,
Plz help me with:
I have a csv file with data separated by ',' and optionally enclosed by "". I want to check each of these values to see if they exceed the specified string length, and if they do I want to cut just that value to the max length allowed and keep the csv format as it... (9 Replies)
I want to create new file for 'NO 0004/01' and 'NO 0005/01' only
How can i do It for shot time
Data FILE Data.txt (Data ~1,000,000 Line)
START
NO 0001/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
TAIL AAA
END
START
B1
NO 0001/02
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
TAIL AAA (2 Replies)
Mar 26 12:32:53 name sshd: 192.168.1.14
Mar 27 12:42:53 name sshd: 192.168.1.14
how to make this data in output as:
"Mar 26 12:32:53","name","sshd","192.168.1.14"
"Mar 27 12:42:53","name","sshd","192.168.1.14"
anyone plzz help me out!!!!!!!!!!!!!! (4 Replies)
Hi,
I need some help with the cut command, can i use it to cut a certain number of characters from string starting from the end.
say my string is like this
some junk data xyz1@pqr.com xyz2@pqr.com some more junk data
I can't exactly say how many email addresses are present in between. But the... (4 Replies)
Hi in a directory i've files having the following name
for_category_info_19990101984301
for_catgry_meta_19991111214601
-------
I just want the name till year and month i.e;
for_category_info_199901
for_catgry_meta_199911
How can i achieve the above string
Thanks (2 Replies)
---------- Post updated at 10:31 AM ---------- Previous update was at 10:28 AM ----------
Hello,
I am trying to get the string cut based on the following needs:
String1=Submitted request 25574824 for CONCURRENT SQLAP RUAPACTUALSEXT Y RUAPACTUALS122313100616.dat "2013/01/12 14:50:44"... (6 Replies)
Three days ago we received an expected notice from our long time data center that they were going dark on Sept 12th.
About one and a half hours ago, after three days of marathon work, I just cut over the unix.com to a new data center with a completely new OS and Ubuntu distribution. (22 Replies)
Discussion started by: Neo
22 Replies
LEARN ABOUT CENTOS
create_user_mapping
CREATE USER MAPPING(7) PostgreSQL 9.2.7 Documentation CREATE USER MAPPING(7)NAME
CREATE_USER_MAPPING - define a new mapping of a user to a foreign server
SYNOPSIS
CREATE USER MAPPING FOR { user_name | USER | CURRENT_USER | PUBLIC }
SERVER server_name
[ OPTIONS ( option 'value' [ , ... ] ) ]
DESCRIPTION
CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a
foreign-data wrapper uses together with the information encapsulated by a foreign server to access an external data resource.
The owner of a foreign server can create user mappings for that server for any user. Also, a user can create a user mapping for his own
user name if USAGE privilege on the server has been granted to the user.
PARAMETERS
user_name
The name of an existing user that is mapped to foreign server. CURRENT_USER and USER match the name of the current user. When PUBLIC
is specified, a so-called public mapping is created that is used when no user-specific mapping is applicable.
server_name
The name of an existing server for which the user mapping is to be created.
OPTIONS ( option 'value' [, ... ] )
This clause specifies the options of the user mapping. The options typically define the actual user name and password of the mapping.
Option names must be unique. The allowed option names and values are specific to the server's foreign-data wrapper.
EXAMPLES
Create a user mapping for user bob, server foo:
CREATE USER MAPPING FOR bob SERVER foo OPTIONS (user 'bob', password 'secret');
COMPATIBILITY
CREATE USER MAPPING conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
ALTER USER MAPPING (ALTER_USER_MAPPING(7)), DROP USER MAPPING (DROP_USER_MAPPING(7)), CREATE FOREIGN DATA WRAPPER
(CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE SERVER (CREATE_SERVER(7))
PostgreSQL 9.2.7 2014-02-17 CREATE USER MAPPING(7)