Copy Tables in PostgreSQL : We have many option for create duplicate tables in database for backup etc.
Example 1 : CREATE TABLE Table_Name as Existing_Table;
Example 2:
Create table copy_tables as select * from original_table;
Popular
-
[root@dev ~]#yum install docker Installed: docker.x86_64 2:1.13.1-162.git64e9980.el7.centos [root@dev ~]# systemctl start do... -
SETOF RECORD : select * from employee -- drop function fn_withouttable() select * from fn_record_emp() as tbl(empid int,empname varchar) ...
-
Refcursor : is used for return multiple rows & used to process a sql statement . Task : Used in Function & Stored Procedure cre...
-
PostgreSQL ALTER TABLE Add column alter table employee_clone add column dept_id integer ; Change data type alter table employee_clone alt...
-
Create table account drop table if exists accounts; create table accounts ( id int generated by default as identity, name varchar(...
No comments:
Post a Comment