Postgresqlデータベーステーブル情報クエリーsql文(更新継続)について
845 ワード
show databases;(mysql) select * from pg_database;(postgresql)
show tables;(mysql)
select * from information_schema.tables where table_schema='public';(postgresql)
desc users;(mysql)
select * from information_schema.columns where table_name='users';(postgresql)
alter table "users" alter column created_date type timestamp;
create or replace function updateTimeType() returns void as
$body$
declare
begin
end;
$body$ language plpgsql;
SELECT *from newprocedure();
DROP FUNCTION newprocedure();