12-19-2008
good Unix emulator for vista PC
Dear experts!
can you please advise if there are good solutions to emulate Unix on a vista PC? I'm on windows by default, as many on my crucial applications are exclusively win-based, so rebooting each time I need UNIX functionality in a double-boot configuration is not my case.. But I do like UNIX, it is very helpful, so I try to build up skills. The wanted emulator should provide for a (nearly?) full UNIX functionality, and, preferrably, be able to not only emulate the terminal but graphic environments like GNOM or others, and to easily exchange files with Win OS. It can be commercial, but of course the freeer the better
)
I tried to search the web - there are options, but it's difficult to figure which one is better. I browsed the forums on unix.com, but the threads are obsolete..
Any comments will be much welcome. Thanks for helping.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
as part of my course i have to do a lot of programming using the universities unix server. i am able to access this from home using telnet but i cannot use axe or anything to edit my files. I was wondering if anyone knew of any software that could enable me yo do this as i like working at 2am when... (1 Reply)
Discussion started by: HALLY
1 Replies
2. UNIX for Dummies Questions & Answers
i have no clue what I am doing with the ed editor since i have never really used it.. the only thing is the sed edittor on the unix emulator I downloaded for windows is rather simple and the man pages are very vague... it doesn't function according to most linux operating systems that envoke sed..... (4 Replies)
Discussion started by: moxxx68
4 Replies
3. UNIX for Advanced & Expert Users
Hi all:
I have windows XP and i want to learn UNIX SHELL PROGRAMMING! can you tell me any unix shell emulator or simulator which i can install on windows and learn unix shell programming (FOR SOME REASON I DONT WANT TO INSTALL LINUX)!!!
PLEASE HELP!
CHEERS (2 Replies)
Discussion started by: ravirajindia
2 Replies
4. UNIX for Dummies Questions & Answers
Hi all:
I have windows XP and i want to learn UNIX SHELL PROGRAMMING! can you tell me any unix shell emulator or simulator which i can install on windows and learn unix shell programming (FOR SOME REASON I DONT WANT TO INSTALL LINUX)!!!
PLEASE HELP!
CHEERS (3 Replies)
Discussion started by: ravirajindia
3 Replies
5. UNIX for Dummies Questions & Answers
Where can I download a unix Emulator for Training and education of the IT personal in my company. (9 Replies)
Discussion started by: st_matan
9 Replies
6. UNIX for Dummies Questions & Answers
would like to have ls, wc -l, etc all availble in this silly dos shell I'm stuck in thanks! (1 Reply)
Discussion started by: robersh
1 Replies
7. UNIX for Dummies Questions & Answers
hello
i have a computer sat around doing nothing so i what to install a version of Unix on it, i then want to access the computer from my pc though my home network e.g router.
The thing is what version of unix should i use there are so many and being new to all of this some advice would be... (2 Replies)
Discussion started by: superdude
2 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I installed unix emulator cygwin, it does not allow me to open vi editor.
Can anybody know if cygwin supports vi.
if not can somebody please refer a good emulator. (5 Replies)
Discussion started by: siquadri
5 Replies
LEARN ABOUT REDHAT
create_view
CREATE
VIEW(7) SQL Commands CREATE VIEW(7)
NAME
CREATE VIEW - define a new view
SYNOPSIS
CREATE [ OR REPLACE ] VIEW view [ ( column name list ) ] AS SELECT query
INPUTS
view The name (optionally schema-qualified) of a view to be created.
column name list
An optional list of names to be used for columns of the view. If given, these names override the column names that would be deduced
from the SQL query.
query An SQL query (that is, a SELECT statement) which will provide the columns and rows of the view.
Refer to SELECT [select(7)] for more information about valid arguments.
OUTPUTS
CREATE VIEW
The message returned if the view is successfully created.
ERROR: Relation 'view' already exists
This error occurs if the view specified already exists in the database.
WARNING: Attribute 'column' has an unknown type
The view will be created having a column with an unknown type if you do not specify it. For example, the following command gives a
warning:
CREATE VIEW vista AS SELECT 'Hello World'
whereas this command does not:
CREATE VIEW vista AS SELECT text 'Hello World'
DESCRIPTION
CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, a query rewrite rule (an ON SELECT rule) is auto-
matically generated to support SELECT operations on views.
CREATE OR REPLACE VIEW is similar, but if a view of the same name already exists, it is replaced. You can only replace a view with a new
query that generates the identical set of columns (i.e., same column names and data types).
If a schema name is given (for example, CREATE VIEW myschema.myview ...) then the view is created in the specified schema. Otherwise it is
created in the current schema (the one at the front of the search path; see CURRENT_SCHEMA()). The view name must be distinct from the
name of any other view, table, sequence, or index in the same schema.
NOTES
Currently, views are read only: the system will not allow an insert, update, or delete on a view. You can get the effect of an updatable
view by creating rules that rewrite inserts, etc. on the view into appropriate actions on other tables. For more information see CREATE
RULE [create_rule(7)].
Use the DROP VIEW statement to drop views.
USAGE
Create a view consisting of all Comedy films:
CREATE VIEW kinds AS
SELECT *
FROM films
WHERE kind = 'Comedy';
SELECT * FROM kinds;
code | title | did | date_prod | kind | len
-------+---------------------------+-----+------------+--------+-------
UA502 | Bananas | 105 | 1971-07-13 | Comedy | 01:22
C_701 | There's a Girl in my Soup | 107 | 1970-06-11 | Comedy | 01:36
(2 rows)
COMPATIBILITY
SQL92
SQL92 specifies some additional capabilities for the CREATE VIEW statement:
CREATE VIEW view [ column [, ...] ]
AS SELECT expression [ AS colname ] [, ...]
FROM table [ WHERE condition ]
[ WITH [ CASCADE | LOCAL ] CHECK OPTION ]
The optional clauses for the full SQL92 command are:
CHECK OPTION
This option is to do with updatable views. All INSERT and UPDATE commands on the view will be checked to ensure data satisfy the
view-defining condition. If they do not, the update will be rejected.
LOCAL Check for integrity on this view.
CASCADE
Check for integrity on this view and on any dependent view. CASCADE is assumed if neither CASCADE nor LOCAL is specified.
CREATE OR REPLACE VIEW is a PostgreSQL language extension.
SQL - Language Statements 2002-11-22 CREATE VIEW(7)