When pasting certain SQL commands into psql in the cygwin window, it beeps and prints a list of some SQL commands.
This SQL:
create or replace view v_software as
select s.id,
s.title,
(s.version_major || '.' || s.version_minor || '.' || s.version_revision) as version,
d.user_id
from software s
inner join downloads d
on s.id = d.software_id
order by title;
Results in this output:
pg=> create or replace view v_software as
pg-> select s.id,
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> s.title,
pg->
ABORT CLUSTER DECLARE&nbs p; GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
<| s.version_minor || '.' || s.version_revision) as version,
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTENALTER COMMENT DELETE INSERT NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> d.user_id
pg-> from software s
pg-> inner join download d
pg->
ABORT CLUSTER DECLARE GRANT MOVE ROLLBACK UNLISTEN
ALTER COMMENT DELETE INSERT&n bsp; NOTIFY SELECT UPDATE
ANALYZE COMMIT DROP LISTEN REINDEX SET VACUUM
BEGIN COPY EXPLAIN LOAD RESET SHOW
CLOSE CREATE FETCH LOCK REVOKE TRUNCATE
pg-> on s.id = d.software_id
pg-> order by title;
CREATE VIEW
I've tried saving the file I'm copying from as both unix and windows formats.
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable.
Sign up now
