pá 17. 9. 2021 v 13:56 odesílatel Daniel Gustafsson <dan...@yesql.se> napsal:
> > On 17 Sep 2021, at 13:51, Pavel Stehule <pavel.steh...@gmail.com> wrote: > > pá 17. 9. 2021 v 13:42 odesílatel Daniel Gustafsson <dan...@yesql.se > <mailto:dan...@yesql.se>> napsal: > > > I am unable to write a filter statement which can > > handle this relname: > > > > CREATE TABLE "a"" > > ""b" (a integer); > > > > Are you able to craft one for that? > > > > I am not able to dump this directly in pg_dump. Is it possible? > > Sure, see below: > > $ ./bin/psql filter > psql (15devel) > Type "help" for help. > > I didn't ask on this I asked if you can use -t and some for filtering this name ? > filter=# create table "a"" > filter"# ""b" (a integer); > CREATE TABLE > filter=# select relname from pg_class order by oid desc limit 1; > relname > --------- > a" + > "b > (1 row) > > filter=# ^D\q > $ ./bin/pg_dump -s filter > -- > -- PostgreSQL database dump > -- > > -- Dumped from database version 15devel > -- Dumped by pg_dump version 15devel > > SET statement_timeout = 0; > SET lock_timeout = 0; > SET idle_in_transaction_session_timeout = 0; > SET client_encoding = 'UTF8'; > SET standard_conforming_strings = on; > SELECT pg_catalog.set_config('search_path', '', false); > SET check_function_bodies = false; > SET xmloption = content; > SET client_min_messages = warning; > SET row_security = off; > > SET default_tablespace = ''; > > SET default_table_access_method = heap; > > -- > -- Name: a" "b; Type: TABLE; Schema: public; Owner: danielg > -- > > CREATE TABLE public."a"" > ""b" ( > a integer > ); > > > ALTER TABLE public."a"" > ""b" OWNER TO danielg; > > -- > -- PostgreSQL database dump complete > -- > > -- > Daniel Gustafsson https://vmware.com/ > >
