08-03-2009
I'm not sure in postfix. In exim you'd skip the aliases and use rewrites.
10 More Discussions You Might Find Interesting
1. IP Networking
I'm looking to enable IP forwarding from a private LAN thru a Solaris Unix box onto a general LAN. Can Anyone tell me how to go about it ? An example of hte command line would be a great help.
Thanx (5 Replies)
Discussion started by: ianf
5 Replies
2. Shell Programming and Scripting
Hello,
I have created a .forward file to automatically forward all e-mails from my unix account to a webmaster account.
I want to know if an e-mail that is carrying a virus could infect my server or the server with the webmaster account, or both servers ? (2 Replies)
Discussion started by: silver40
2 Replies
3. IP Networking
Can anyone out there explain to me how to multi home a nic? I hate to say it but I'm a windows guy forced to learn Unix. The issue I currently have is I can't changed the ip on eth0, but in order to make it pingable by other servers I need to multi home the nic with a totally seperate Ip. Any help... (1 Reply)
Discussion started by: win2khater
1 Replies
4. UNIX for Dummies Questions & Answers
Hi, I'd like to forward my Emails from my domain to my gmx and web.de accounts. For example:
bla@blabla.de to bla@gmx.de
blabla@blabla.de to bla@web.de
How to do this ? I know that .forward forwards all emails to one account, but that's not what I want. (8 Replies)
Discussion started by: sai
8 Replies
5. Solaris
Hello everybody,
I have solaris 10 running on SF v890, I need to forward some sepecific root mails resulted from some application, (or all root mails) to other machine running Solaris 10 also.
does it have anything to do with mail relay, or just change the log settings???
Thanks in Advance... (1 Reply)
Discussion started by: aladdin
1 Replies
6. Cybersecurity
Hi,
from my workplace we use a proxy to connect to the outside world, including external ssh servers.
The problem is that the server is seeing the connection coming from the proxy and knows nothing about the client behind it. The ssh connection itself works fine, but x-forwarding does not work as... (1 Reply)
Discussion started by: vampirodolce
1 Replies
7. Linux
Hello All
I have the following setup of a network. Client machines sends requests to the server which is (192.168.1.50) running on Ubuntu server 8.04. And this server forwards all incoming traffic from clients to another server (192.168.1.100) when it's available. The availability is checked... (0 Replies)
Discussion started by: Anuradhai4i
0 Replies
8. Shell Programming and Scripting
Trying to redirect email received to shell script using the following command
in the .forward file
\vudum001, "| /home/vudum001/kk $1"
/home/vudum001 : Home directory
kk script file in home directory
kk file contents
echo $1 >>file1
gave 755 access to .forward as well as script... (1 Reply)
Discussion started by: mvudugula
1 Replies
9. Cybersecurity
I want if I send a mail to somebody, he will not be able to forward it to anybody. How it is possible in MS outlook? (1 Reply)
Discussion started by: amisubha
1 Replies
10. UNIX for Advanced & Expert Users
Hi experts,
We have windows machine ( A ) in one network & 2 Linux Servers ( B & C ) in another network. There is a firewall between these 2 networks and SSH (TCP/22) & HTTPS (TCP/443) are allowed from A to B only (but not to C). There is no personal firewall / iptables running on any machine.... (1 Reply)
Discussion started by: magnus29
1 Replies
LEARN ABOUT SUSE
create_domain
CREATE
DOMAIN(7) SQL Commands CREATE DOMAIN(7)
NAME
CREATE DOMAIN - define a new domain
SYNOPSIS
CREATE DOMAIN name [ AS ] data_type
[ DEFAULT expression ]
[ constraint [ ... ] ]
where constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | CHECK (expression) }
DESCRIPTION
CREATE DOMAIN creates a new domain. A domain is essentially a data type with optional constraints (restrictions on the allowed set of val-
ues). The user who defines a domain becomes its owner.
If a schema name is given (for example, CREATE DOMAIN myschema.mydomain ...) then the domain is created in the specified schema. Otherwise
it is created in the current schema. The domain name must be unique among the types and domains existing in its schema.
Domains are useful for abstracting common constraints on fields into a single location for maintenance. For example, several tables might
contain email address columns, all requiring the same CHECK constraint to verify the address syntax. Define a domain rather than setting
up each table's constraint individually.
PARAMETERS
name The name (optionally schema-qualified) of a domain to be created.
data_type
The underlying data type of the domain. This can include array specifiers.
DEFAULT expression
The DEFAULT clause specifies a default value for columns of the domain data type. The value is any variable-free expression (but
subqueries are not allowed). The data type of the default expression must match the data type of the domain. If no default value is
specified, then the default value is the null value.
The default expression will be used in any insert operation that does not specify a value for the column. If a default value is
defined for a particular column, it overrides any default associated with the domain. In turn, the domain default overrides any
default value associated with the underlying data type.
CONSTRAINT constraint_name
An optional name for a constraint. If not specified, the system generates a name.
NOT NULL
Values of this domain are not allowed to be null.
NULL Values of this domain are allowed to be null. This is the default.
This clause is only intended for compatibility with nonstandard SQL databases. Its use is discouraged in new applications.
CHECK (expression)
CHECK clauses specify integrity constraints or tests which values of the domain must satisfy. Each constraint must be an expression
producing a Boolean result. It should use the key word VALUE to refer to the value being tested.
Currently, CHECK expressions cannot contain subqueries nor refer to variables other than VALUE.
EXAMPLES
This example creates the us_postal_code data type and then uses the type in a table definition. A regular expression test is used to verify
that the value looks like a valid US postal code:
CREATE DOMAIN us_postal_code AS TEXT
CHECK(
VALUE ~ '^\d{5}$'
OR VALUE ~ '^\d{5}-\d{4}$'
);
CREATE TABLE us_snail_addy (
address_id SERIAL PRIMARY KEY,
street1 TEXT NOT NULL,
street2 TEXT,
street3 TEXT,
city TEXT NOT NULL,
postal us_postal_code NOT NULL
);
COMPATIBILITY
The command CREATE DOMAIN conforms to the SQL standard.
SEE ALSO
ALTER DOMAIN [alter_domain(7)], DROP DOMAIN [drop_domain(7)]
SQL - Language Statements 2010-05-14 CREATE DOMAIN(7)