public.swh_mktemp_content_language.sql
No OneTemporary
Actions

Size

1 KB

Subscribers

None

public.swh_mktemp_content_language.sql
View Options

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 9.6.2
	-- Dumped by pg_dump version 9.6.2

	SET statement_timeout = 0;
	SET lock_timeout = 0;
	SET idle_in_transaction_session_timeout = 0;
	SET client_encoding = 'UTF8';
	SET standard_conforming_strings = on;
	SET check_function_bodies = false;
	SET client_min_messages = warning;
	SET row_security = off;

	SET search_path = public, pg_catalog;

	--
	-- Name: swh_mktemp_content_language(); Type: FUNCTION; Schema: public; Owner: swhstorage
	--

	CREATE FUNCTION swh_mktemp_content_language() RETURNS void
	LANGUAGE sql
	AS $$
	create temporary table tmp_content_language (
	like content_language including defaults
	) on commit drop;
	alter table tmp_content_language
	drop column indexer_configuration_id,
	add column tool_name text,
	add column tool_version text;
	$$;


	ALTER FUNCTION public.swh_mktemp_content_language() OWNER TO swhstorage;

	--
	-- Name: FUNCTION swh_mktemp_content_language(); Type: COMMENT; Schema: public; Owner: swhstorage
	--

	COMMENT ON FUNCTION swh_mktemp_content_language() IS 'Helper table to add content language';


	--
	-- PostgreSQL database dump complete
	--