You could use something like
Since you did not show how your file looks like, I can only guess, but this sed thing up there is universal so you exchange the ö and oe just vs. the letters you want to change.
Hello,
I'm trying to type in foreign characters (á, é, í, ñ...) from the bash when doing a Telnet to my UNIX account.
So far it only allows me to type in the standard character set (up to ASCII 128). I need this to feed parameters to certains scripts and programs.
Thanks!
Miguel (4 Replies)
I was wondering if somebody could help me with something on UNIX. I have a file that looks like this -
"nelson,bill","bill","123 Main St","Mpls","MN",55444,8877,william
I want to replace all comma with pipes (|), except if the comma is within double quotes. (The first field is an example of... (8 Replies)
Hi,
I'm hoping that someone might be able to help me with this problem:
I have already added new code to several existing Lex rules to accept the following foreign characters: å ä ö Å Ä Ö æ Æ ø Ø ü Ü ß. The code looks like this:
/*Nathalie Stern, 080121 - Add å ä ö Å Ä Ö æ Æ ø Ø ü Ü ß handling to function*/... (1 Reply)
I have a flat file and have foreign characters in three fields.
Can somebody tell me how to get rid of these special characters?
It's very urgent because without this my process is failing.
Thanks in advance.
Angielina (1 Reply)
I have a flat file and have foreign characters in three fields.
Can somebody tell me how to get rid of these special characters?
It's very urgent because without this my process is failing.
Thanks in advance.
Angielina (2 Replies)
Hi
I have the fixed width flat file having the following data
12345aaaaaaaaaabbbbbbbbbb
12365sssssssssscccccccccc
12365sssss
12367ddddddddddvvvvvvvvvv
12367 vvvvv
Here the first column is length 5 second is length 10 third is length 10
if the second or third column exceeds... (3 Replies)
hello everybody
i am looking for a shell to cut a flat file (with a long unique line) according to a certain number of characters and redirect every result to an output file.
here is an example
MyFile :
12 3 456 12 3 456 12 3 456 .....
and i took every 9-characters including BLANKS... (6 Replies)
HI,
can any one help me please ..
i have flat file like
qwer123rt ass3242ccf jjk654
kjh838ppp nhdg453ok hdkk34
i want remove numeric characters in the flat file
i want output like this
qwerrt assccf jjk
kjhppp nhdgok hdkk
help me... (4 Replies)
Hi....I need one help....
I'm having a files which is having the data as follows...
a
b
c c
d d d
e
f
Now I need to find out distinct characters from this file and the output should be as follows -
a
b
c
d
e
f
Can you please help me on this? I'm using KSH script. (18 Replies)
Hi,
Do we have Foreign Key concept in File system like UNIX, as we have in DBMS?? If yes, Can you please tell me how it is implemented in File System?
Thanks & Regards,
Archana (2 Replies)
Discussion started by: Archana Batta
2 Replies
LEARN ABOUT CENTOS
create_server
CREATE SERVER(7) PostgreSQL 9.2.7 Documentation CREATE SERVER(7)NAME
CREATE_SERVER - define a new foreign server
SYNOPSIS
CREATE SERVER server_name [ TYPE 'server_type' ] [ VERSION 'server_version' ]
FOREIGN DATA WRAPPER fdw_name
[ OPTIONS ( option 'value' [, ... ] ) ]
DESCRIPTION
CREATE SERVER defines a new foreign server. The user who defines the server becomes its owner.
A foreign server typically encapsulates connection information that a foreign-data wrapper uses to access an external data resource.
Additional user-specific connection information may be specified by means of user mappings.
The server name must be unique within the database.
Creating a server requires USAGE privilege on the foreign-data wrapper being used.
PARAMETERS
server_name
The name of the foreign server to be created.
server_type
Optional server type.
server_version
Optional server version.
fdw_name
The name of the foreign-data wrapper that manages the server.
OPTIONS ( option 'value' [, ... ] )
This clause specifies the options for the server. The options typically define the connection details of the server, but the actual
names and values are dependent on the server's foreign-data wrapper.
NOTES
When using the dblink module (see dblink), the foreign server name can be used as an argument of the dblink_connect(3) function to indicate
the connection parameters. See also there for more examples. It is necessary to have the USAGE privilege on the foreign server to be able
to use it in this way.
EXAMPLES
Create a server foo that uses the built-in foreign-data wrapper default:
CREATE SERVER foo FOREIGN DATA WRAPPER "default";
Create a server myserver that uses the foreign-data wrapper pgsql:
CREATE SERVER myserver FOREIGN DATA WRAPPER pgsql OPTIONS (host 'foo', dbname 'foodb', port '5432');
COMPATIBILITY
CREATE SERVER conforms to ISO/IEC 9075-9 (SQL/MED).
SEE ALSO
ALTER SERVER (ALTER_SERVER(7)), DROP SERVER (DROP_SERVER(7)), CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), CREATE USER
MAPPING (CREATE_USER_MAPPING(7))
PostgreSQL 9.2.7 2014-02-17 CREATE SERVER(7)