CreateTable1_fromTable2.htm
Creating a table from Another table:
 Source Table:

Cloned Table:

Screen shots from pgAdminIII

Testing Clone Table "emp4"

Create an Index :

CREATE INDEX idx_emp4_lname
ON emp4
USING btree
(lname)
WITH (FILLFACTOR=98);
ALTER TABLE emp4 CLUSTER ON idx_emp4_lname;
Now : Crate a function:

CREATE OR REPLACE FUNCTION get_emp4bylname(lname varchar)
RETURNS SETOF int AS
$$
SELECT eid FROM emp4 WHERE lname LIKE $1;
$$
LANGUAGE 'sql' ROWS 3 STABLE;