· 8 years ago · Apr 20, 2018, 09:54 AM
1Last login: Fri Apr 20 08:46:47 on console
2You have mail.
3MacBook-Pro-de-Alexandre-2:~ cia$ postgree
4-bash: postgree: command not found
5MacBook-Pro-de-Alexandre-2:~ cia$ postgre
6-bash: postgre: command not found
7MacBook-Pro-de-Alexandre-2:~ cia$ postgresql
8-bash: postgresql: command not found
9MacBook-Pro-de-Alexandre-2:~ cia$ pg_ctl -D /usr/local/var/postgres start
10-bash: pg_ctl: command not found
11MacBook-Pro-de-Alexandre-2:~ cia$ cd pg_ctl -D /usr/local/var/postgres
12-bash: cd: pg_ctl: No such file or directory
13MacBook-Pro-de-Alexandre-2:~ cia$ cd /usr
14MacBook-Pro-de-Alexandre-2:usr cia$ cd local
15MacBook-Pro-de-Alexandre-2:local cia$ cd var
16MacBook-Pro-de-Alexandre-2:var cia$ ls
17cache db homebrew log run
18MacBook-Pro-de-Alexandre-2:var cia$ cd
19MacBook-Pro-de-Alexandre-2:~ cia$ cd /Library
20MacBook-Pro-de-Alexandre-2:Library cia$ ls
21Application Support Input Methods QuickLook
22Audio Internet Plug-Ins QuickTime
23Caches Java Receipts
24ColorPickers Keyboard Layouts Ruby
25ColorSync Keychains Sandbox
26Components LaunchAgents Screen Savers
27Compositions LaunchDaemons ScriptingAdditions
28Contextual Menu Items Logs Scripts
29CoreAnalytics Managed Preferences Security
30CoreMediaIO MessageTracer Speech
31Desktop Pictures Messages Spotlight
32Developer Modem Scripts StagedExtensions
33DirectoryServices OpenDirectory StartupItems
34Documentation PDF Services SystemMigration
35Extensions Perl SystemProfiler
36Filesystems PostgreSQL Updates
37Fonts PreferencePanes User Pictures
38Frameworks Preferences Video
39GPUBundles Printers WebServer
40Graphics PrivilegedHelperTools Widgets
41Image Capture Python
42MacBook-Pro-de-Alexandre-2:Library cia$ cd PostgreSQL/
43MacBook-Pro-de-Alexandre-2:PostgreSQL cia$ ;s
44-bash: syntax error near unexpected token `;'
45MacBook-Pro-de-Alexandre-2:PostgreSQL cia$ ls
4610
47MacBook-Pro-de-Alexandre-2:PostgreSQL cia$ pg_ctl start
48-bash: pg_ctl: command not found
49MacBook-Pro-de-Alexandre-2:PostgreSQL cia$ start
50-bash: start: command not found
51MacBook-Pro-de-Alexandre-2:PostgreSQL cia$ cd
52MacBook-Pro-de-Alexandre-2:~ cia$ brew services start postgresql
53==> Tapping homebrew/services
54Cloning into '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-services'...
55remote: Counting objects: 14, done.
56remote: Compressing objects: 100% (10/10), done.
57remote: Total 14 (delta 0), reused 8 (delta 0), pack-reused 0
58Unpacking objects: 100% (14/14), done.
59Tapped 0 formulae (43 files, 55.2KB)
60Error: Formula `postgresql` is not installed.
61MacBook-Pro-de-Alexandre-2:~ cia$ brew install postgresql
62Updating Homebrew...
63==> Auto-updated Homebrew!
64Updated 2 taps (homebrew/core, caskroom/cask).
65==> New Formulae
66deark
67==> Updated Formulae
68abcmidi gnuradio ocrmypdf
69akamai gpgme oniguruma
70amazon-ecs-cli gphoto2 openimageio
71annie gr-osmosdr osquery
72ansible gradle osrm-backend
73apache-arrow grails packetbeat
74apm-server gtk+3 pam-u2f
75artifactory haproxy pcre2
76atlassian-cli hcloud pdftoedn
77auditbeat heartbeat pdftoipe
78bacula-fd heroku pgpool-ii
79bartycrouch hlint phpunit
80bitcoin jbake planck
81blueutil jpegoptim poppler
82boost juju povray
83boost-bcp kedge presto
84boost-build kibana pyexiv2
85boost-mpi kompose qmmp
86boost-python kotlin quantlib
87boost-python3 kubeless rhash
88caddy ledger scala@2.11
89cake lgogdownloader sdcc
90calicoctl libbitcoin shml
91camlp5 libgphoto2 silk
92chronograf libgsf skafos
93clac libphonenumber sonarqube
94clamav librealsense source-highlight
95cmake libstfl spotbugs
96convox libtorrent-rasterbar swiftformat
97diff-pdf libuv telegraf
98dockviz logstash tmuxinator-completion
99elasticsearch lolcat trafficserver
100elasticsearch@5.6 macvim txr
101erlang metaproxy typescript
102etsh metricbeat uhd
103feh mkvtoolnix upscaledb
104filebeat monero webpack
105fio mongodb wesnoth
106fn mysql widelands
107folly mysql-sandbox wireguard-tools
108freetds mysql@5.5 wla-dx
109fuego mysql@5.6 xxhash
110gegl ncmpcpp ykman
111ghc node-build zsh
112gjs nomad
113glslang nudoku
114==> Renamed Formulae
115geth -> ethereum
116==> Deleted Formulae
117monotone
118
119==> Downloading https://homebrew.bintray.com/bottles/postgresql-10.3.high_sierra
120==> Downloading from https://akamai.bintray.com/63/632a988ae9a6b45acd3fca3f05af7
121######################################################################## 100.0%
122==> Pouring postgresql-10.3.high_sierra.bottle.tar.gz
123==> /usr/local/Cellar/postgresql/10.3/bin/initdb /usr/local/var/postgres
124==> Caveats
125To migrate existing data from a previous major version of PostgreSQL run:
126 brew postgresql-upgrade-database
127
128To have launchd start postgresql now and restart at login:
129 brew services start postgresql
130Or, if you don't want/need a background service you can just run:
131 pg_ctl -D /usr/local/var/postgres start
132==> Summary
133🺠/usr/local/Cellar/postgresql/10.3: 3,383 files, 39.2MB
134MacBook-Pro-de-Alexandre-2:~ cia$ brew services start postgresql
135==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)
136MacBook-Pro-de-Alexandre-2:~ cia$ CREATE DATABASE DEv2
137-bash: CREATE: command not found
138MacBook-Pro-de-Alexandre-2:~ cia$ CREATE DATABASE DEv2;
139-bash: CREATE: command not found
140MacBook-Pro-de-Alexandre-2:~ cia$ \l
141-bash: l: command not found
142MacBook-Pro-de-Alexandre-2:~ cia$ ls
143Applications Documents Google Drive Movies Pictures WebstormProjects
144Desktop Downloads Library Music Public
145MacBook-Pro-de-Alexandre-2:~ cia$ cd /usr/local/var/postgres
146MacBook-Pro-de-Alexandre-2:postgres cia$ ls
147PG_VERSION pg_commit_ts pg_ident.conf pg_notify pg_snapshots pg_subtrans pg_wal postgresql.conf
148base pg_dynshmem pg_logical pg_replslot pg_stat pg_tblspc pg_xact
149global pg_hba.conf pg_multixact pg_serial pg_stat_tmp pg_twophase postgresql.auto.conf
150MacBook-Pro-de-Alexandre-2:postgres cia$ CREATE DATABASE Dev2
151-bash: CREATE: command not found
152MacBook-Pro-de-Alexandre-2:postgres cia$ clear
153
154MacBook-Pro-de-Alexandre-2:postgres cia$ ls
155PG_VERSION pg_commit_ts pg_ident.conf pg_notify pg_snapshots pg_subtrans pg_wal postgresql.conf
156base pg_dynshmem pg_logical pg_replslot pg_stat pg_tblspc pg_xact
157global pg_hba.conf pg_multixact pg_serial pg_stat_tmp pg_twophase postgresql.auto.conf
158MacBook-Pro-de-Alexandre-2:postgres cia$ \l
159-bash: l: command not found
160MacBook-Pro-de-Alexandre-2:postgres cia$ sql -I
161-bash: sql: command not found
162MacBook-Pro-de-Alexandre-2:postgres cia$ sql -V
163-bash: sql: command not found
164MacBook-Pro-de-Alexandre-2:postgres cia$ psql -V
165psql (PostgreSQL) 10.3
166MacBook-Pro-de-Alexandre-2:postgres cia$ psql -U
167psql: option requires an argument -- U
168Try "psql --help" for more information.
169MacBook-Pro-de-Alexandre-2:postgres cia$ psql -U postgres
170Password for user postgres:
171psql: FATAL: password authentication failed for user "postgres"
172MacBook-Pro-de-Alexandre-2:postgres cia$ psql -U postgres
173Password for user postgres:
174psql: FATAL: password authentication failed for user "postgres"
175MacBook-Pro-de-Alexandre-2:postgres cia$ psql -U postgres
176Password for user postgres:
177psql (10.3)
178Type "help" for help.
179
180postgres=# CREATE DATABASE Dev2$
181postgres-# ;
182CREATE DATABASE
183postgres=# \c Dev2
184FATAL: database "Dev2" does not exist
185Previous connection kept
186postgres=# \c dev2
187FATAL: database "dev2" does not exist
188Previous connection kept
189postgres=# CREATE DATABASE dev2;
190CREATE DATABASE
191postgres=# \c dev2
192You are now connected to database "dev2" as user "postgres".
193dev2=# --
194dev2=# -- PostgreSQL database dump
195dev2=# --
196dev2=#
197dev2=# SET statement_timeout = 0;
198SET
199dev2=# SET lock_timeout = 0;
200SET
201dev2=# SET client_encoding = 'UTF8';
202SET
203dev2=# SET standard_conforming_strings = on;
204SET
205dev2=# SET check_function_bodies = false;
206SET
207dev2=# SET client_min_messages = warning;
208SET
209dev2=#
210dev2=# --
211dev2=# -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
212dev2=# --
213dev2=#
214dev2=# CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
215CREATE EXTENSION
216dev2=#
217dev2=#
218dev2=# --
219dev2=# -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
220dev2=# --
221dev2=#
222dev2=# COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
223COMMENT
224dev2=#
225dev2=#
226dev2=# SET search_path = public, pg_catalog;
227SET
228dev2=#
229dev2=# --
230dev2=# -- Name: numeroter(character varying, character varying); Type: FUNCTION; Schema: public; Owner: postgres
231dev2=# --
232dev2=#
233dev2=# CREATE FUNCTION numeroter(prefixe character varying, nom_sequence character varying) RETURNS character varying
234dev2-# LANGUAGE plpgsql
235dev2-# AS $$
236dev2$# begin
237dev2$# return concat(prefixe,ltrim(to_char(nextval(nom_sequence),'000000')));
238dev2$# end;
239dev2$# $$;
240CREATE FUNCTION
241dev2=#
242dev2=#
243dev2=# ALTER FUNCTION public.numeroter(prefixe character varying, nom_sequence character varying) OWNER TO postgres;
244ALTER FUNCTION
245dev2=#
246dev2=# --
247dev2=# -- Name: somme(integer, integer); Type: FUNCTION; Schema: public; Owner: postgres
248dev2=# --
249dev2=#
250dev2=# CREATE FUNCTION somme(x integer, y integer) RETURNS integer
251dev2-# LANGUAGE plpgsql
252dev2-# AS $$
253dev2$# begin
254dev2$# return x+y;
255dev2$#
256dev2$# end;
257dev2$#
258dev2$#
259dev2$# $$;
260CREATE FUNCTION
261dev2=#
262dev2=#
263dev2=# ALTER FUNCTION public.somme(x integer, y integer) OWNER TO postgres;
264ALTER FUNCTION
265dev2=#
266dev2=# SET default_tablespace = '';
267SET
268dev2=#
269dev2=# SET default_with_oids = false;
270SET
271dev2=#
272dev2=# --
273dev2=# -- Name: commande; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
274dev2=# --
275dev2=#
276dev2=# CREATE TABLE commande (
277dev2(# id integer NOT NULL,
278dev2(# numerocommande character varying(20) NOT NULL,
279dev2(# datecommande timestamp without time zone,
280dev2(# tiers_id integer NOT NULL,
281dev2(# typecommande character varying(20)
282dev2(# );
283CREATE TABLE
284dev2=#
285dev2=#
286dev2=# ALTER TABLE public.commande OWNER TO postgres;
287ALTER TABLE
288dev2=#
289dev2=# --
290dev2=# -- Name: appro; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
291dev2=# --
292dev2=#
293dev2=# CREATE TABLE appro (
294dev2(# CONSTRAINT appro_check CHECK ((((numerocommande)::text ~~ 'APP%'::text) AND ((typecommande)::text = 'APP'::text)))
295dev2(# )
296dev2-# INHERITS (commande);
297CREATE TABLE
298dev2=#
299dev2=#
300dev2=# ALTER TABLE public.appro OWNER TO postgres;
301ALTER TABLE
302dev2=#
303dev2=# --
304dev2=# -- Name: seq_numero_article; Type: SEQUENCE; Schema: public; Owner: postgres
305dev2=# --
306dev2=#
307dev2=# CREATE SEQUENCE seq_numero_article
308dev2-# START WITH 1
309dev2-# INCREMENT BY 1
310dev2-# NO MINVALUE
311dev2-# NO MAXVALUE
312dev2-# CACHE 1;
313CREATE SEQUENCE
314dev2=#
315dev2=#
316dev2=# ALTER TABLE public.seq_numero_article OWNER TO postgres;
317ALTER TABLE
318dev2=#
319dev2=# --
320dev2=# -- Name: article; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
321dev2=# --
322dev2=#
323dev2=# CREATE TABLE article (
324dev2(# id integer NOT NULL,
325dev2(# numeroarticle character varying(20) DEFAULT ('ART'::text || ltrim(to_char(nextval('seq_numero_article'::regclass), '00000'::text))) NOT NULL,
326dev2(# designation character varying(250),
327dev2(# prixunitaire numeric(10,2)
328dev2(# );
329CREATE TABLE
330dev2=#
331dev2=#
332dev2=# ALTER TABLE public.article OWNER TO postgres;
333ALTER TABLE
334dev2=#
335dev2=# --
336dev2=# -- Name: article_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
337dev2=# --
338dev2=#
339dev2=# CREATE SEQUENCE article_id_seq
340dev2-# START WITH 1
341dev2-# INCREMENT BY 1
342dev2-# NO MINVALUE
343dev2-# NO MAXVALUE
344dev2-# CACHE 1;
345CREATE SEQUENCE
346dev2=#
347dev2=#
348dev2=# ALTER TABLE public.article_id_seq OWNER TO postgres;
349ALTER TABLE
350dev2=#
351dev2=# --
352dev2=# -- Name: article_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
353dev2=# --
354dev2=#
355dev2=# ALTER SEQUENCE article_id_seq OWNED BY article.id;
356ALTER SEQUENCE
357dev2=#
358dev2=#
359dev2=# --
360dev2=# -- Name: seq_numero_tiers; Type: SEQUENCE; Schema: public; Owner: postgres
361dev2=# --
362dev2=#
363dev2=# CREATE SEQUENCE seq_numero_tiers
364dev2-# START WITH 200
365dev2-# INCREMENT BY 1
366dev2-# NO MINVALUE
367dev2-# NO MAXVALUE
368dev2-# CACHE 1;
369CREATE SEQUENCE
370dev2=#
371dev2=#
372dev2=# ALTER TABLE public.seq_numero_tiers OWNER TO postgres;
373ALTER TABLE
374dev2=#
375dev2=# --
376dev2=# -- Name: tiers; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
377dev2=# --
378dev2=#
379dev2=# CREATE TABLE tiers (
380dev2(# id integer NOT NULL,
381dev2(# numerotiers character varying(20) DEFAULT concat('TIERS', ltrim(to_char(nextval('seq_numero_tiers'::regclass), '000000'::text))) NOT NULL,
382dev2(# nomtiers character varying(250),
383dev2(# adressetiers character varying(250)
384dev2(# );
385CREATE TABLE
386dev2=#
387dev2=#
388dev2=# ALTER TABLE public.tiers OWNER TO postgres;
389ALTER TABLE
390dev2=#
391dev2=# --
392dev2=# -- Name: client; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
393dev2=# --
394dev2=#
395dev2=# CREATE TABLE client (
396dev2(# CONSTRAINT client_numerotiers_check CHECK (((numerotiers)::text ~~ 'CLT%'::text))
397dev2(# )
398dev2-# INHERITS (tiers);
399CREATE TABLE
400dev2=#
401dev2=#
402dev2=# ALTER TABLE public.client OWNER TO postgres;
403ALTER TABLE
404dev2=#
405dev2=# --
406dev2=# -- Name: commande_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
407dev2=# --
408dev2=#
409dev2=# CREATE SEQUENCE commande_id_seq
410dev2-# START WITH 1
411dev2-# INCREMENT BY 1
412dev2-# NO MINVALUE
413dev2-# NO MAXVALUE
414dev2-# CACHE 1;
415CREATE SEQUENCE
416dev2=#
417dev2=#
418dev2=# ALTER TABLE public.commande_id_seq OWNER TO postgres;
419ALTER TABLE
420dev2=#
421dev2=# --
422dev2=# -- Name: commande_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
423dev2=# --
424dev2=#
425dev2=# ALTER SEQUENCE commande_id_seq OWNED BY commande.id;
426ALTER SEQUENCE
427dev2=#
428dev2=#
429dev2=# --
430dev2=# -- Name: seq_numero_frs; Type: SEQUENCE; Schema: public; Owner: postgres
431dev2=# --
432dev2=#
433dev2=# CREATE SEQUENCE seq_numero_frs
434dev2-# START WITH 50
435dev2-# INCREMENT BY 1
436dev2-# NO MINVALUE
437dev2-# NO MAXVALUE
438dev2-# CACHE 1;
439CREATE SEQUENCE
440dev2=#
441dev2=#
442dev2=# ALTER TABLE public.seq_numero_frs OWNER TO postgres;
443ALTER TABLE
444dev2=#
445dev2=# --
446dev2=# -- Name: tiers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
447dev2=# --
448dev2=#
449dev2=# CREATE SEQUENCE tiers_id_seq
450dev2-# START WITH 1
451dev2-# INCREMENT BY 1
452dev2-# NO MINVALUE
453dev2-# NO MAXVALUE
454dev2-# CACHE 1;
455CREATE SEQUENCE
456dev2=#
457dev2=#
458dev2=# ALTER TABLE public.tiers_id_seq OWNER TO postgres;
459ALTER TABLE
460dev2=#
461dev2=# --
462dev2=# -- Name: tiers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
463dev2=# --
464dev2=#
465dev2=# ALTER SEQUENCE tiers_id_seq OWNED BY tiers.id;
466ALTER SEQUENCE
467dev2=#
468dev2=#
469dev2=# --
470dev2=# -- Name: fournisseur; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
471dev2=# --
472dev2=#
473dev2=# CREATE TABLE fournisseur (
474dev2(# id integer DEFAULT nextval('tiers_id_seq'::regclass),
475dev2(# numerotiers character varying(20) DEFAULT concat('FRS', ltrim(to_char(nextval('seq_numero_frs'::regclass), '000000'::text))),
476dev2(# nomtiers character varying(250),
477dev2(# adressetiers character varying(250),
478dev2(# CONSTRAINT fournisseur_numerotiers_check CHECK (((numerotiers)::text ~~ 'FRS%'::text))
479dev2(# )
480dev2-# INHERITS (tiers);
481CREATE TABLE
482dev2=#
483dev2=#
484dev2=# ALTER TABLE public.fournisseur OWNER TO postgres;
485ALTER TABLE
486dev2=#
487dev2=# --
488dev2=# -- Name: seq_numero; Type: SEQUENCE; Schema: public; Owner: postgres
489dev2=# --
490dev2=#
491dev2=# CREATE SEQUENCE seq_numero
492dev2-# START WITH 57
493dev2-# INCREMENT BY 1
494dev2-# NO MINVALUE
495dev2-# NO MAXVALUE
496dev2-# CACHE 1;
497CREATE SEQUENCE
498dev2=#
499dev2=#
500dev2=# ALTER TABLE public.seq_numero OWNER TO postgres;
501ALTER TABLE
502dev2=#
503dev2=# --
504dev2=# -- Name: seq_numero_appro; Type: SEQUENCE; Schema: public; Owner: postgres
505dev2=# --
506dev2=#
507dev2=# CREATE SEQUENCE seq_numero_appro
508dev2-# START WITH 100
509dev2-# INCREMENT BY 1
510dev2-# NO MINVALUE
511dev2-# NO MAXVALUE
512dev2-# CACHE 1;
513CREATE SEQUENCE
514dev2=#
515dev2=#
516dev2=# ALTER TABLE public.seq_numero_appro OWNER TO postgres;
517ALTER TABLE
518dev2=#
519dev2=# --
520dev2=# -- Name: seq_numero_client; Type: SEQUENCE; Schema: public; Owner: postgres
521dev2=# --
522dev2=#
523dev2=# CREATE SEQUENCE seq_numero_client
524dev2-# START WITH 500
525dev2-# INCREMENT BY 1
526dev2-# NO MINVALUE
527dev2-# NO MAXVALUE
528dev2-# CACHE 1;
529CREATE SEQUENCE
530dev2=#
531dev2=#
532dev2=# ALTER TABLE public.seq_numero_client OWNER TO postgres;
533ALTER TABLE
534dev2=#
535dev2=# --
536dev2=# -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
537dev2=# --
538dev2=#
539dev2=# ALTER TABLE ONLY appro ALTER COLUMN id SET DEFAULT nextval('commande_id_seq'::regclass);
540ALTER TABLE
541dev2=#
542dev2=#
543dev2=# --
544dev2=# -- Name: numerocommande; Type: DEFAULT; Schema: public; Owner: postgres
545dev2=# --
546dev2=#
547dev2=# ALTER TABLE ONLY appro ALTER COLUMN numerocommande SET DEFAULT numeroter('APP'::character varying, 'seq_numero_appro'::character varying);
548ALTER TABLE
549dev2=#
550dev2=#
551dev2=# --
552dev2=# -- Name: typecommande; Type: DEFAULT; Schema: public; Owner: postgres
553dev2=# --
554dev2=#
555dev2=# ALTER TABLE ONLY appro ALTER COLUMN typecommande SET DEFAULT 'APP'::character varying;
556ALTER TABLE
557dev2=#
558dev2=#
559dev2=# --
560dev2=# -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
561dev2=# --
562dev2=#
563dev2=# ALTER TABLE ONLY article ALTER COLUMN id SET DEFAULT nextval('article_id_seq'::regclass);
564ALTER TABLE
565dev2=#
566dev2=#
567dev2=# --
568dev2=# -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
569dev2=# --
570dev2=#
571dev2=# ALTER TABLE ONLY client ALTER COLUMN id SET DEFAULT nextval('tiers_id_seq'::regclass);
572ALTER TABLE
573dev2=#
574dev2=#
575dev2=# --
576dev2=# -- Name: numerotiers; Type: DEFAULT; Schema: public; Owner: postgres
577dev2=# --
578dev2=#
579dev2=# ALTER TABLE ONLY client ALTER COLUMN numerotiers SET DEFAULT concat('CLT', ltrim(to_char(nextval('seq_numero_client'::regclass), '000000'::text)));
580ALTER TABLE
581dev2=#
582dev2=#
583dev2=# --
584dev2=# -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
585dev2=# --
586dev2=#
587dev2=# ALTER TABLE ONLY commande ALTER COLUMN id SET DEFAULT nextval('commande_id_seq'::regclass);
588ALTER TABLE
589dev2=#
590dev2=#
591dev2=# --
592dev2=# -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
593dev2=# --
594dev2=#
595dev2=# ALTER TABLE ONLY tiers ALTER COLUMN id SET DEFAULT nextval('tiers_id_seq'::regclass);
596ALTER TABLE
597dev2=#
598dev2=#
599dev2=# --
600dev2=# -- Data for Name: appro; Type: TABLE DATA; Schema: public; Owner: postgres
601dev2=# --
602dev2=#
603dev2=# COPY appro (id, numerocommande, datecommande, tiers_id, typecommande) FROM stdin;
604Enter data to be copied followed by a newline.
605End with a backslash and a period on a line by itself, or an EOF signal.
606>> 4 APP000102 2017-01-15 00:00:00 10 APP
6075 APP000103 2017-02-10 00:00:00 11 APP
608\.
609
610
611--
612-- Data for Name: article; Type: TABLE DATA; Schema: public; Owner: postgres
613--
614
615COPY article (id, numeroarticle, designation, prixunitaire) FROM stdin;
6161 4 Biere castel 2.50
6172 5 Jus orange 1.50l 2.50
6183 6 Stylo 2.50
6194 ART00010 Cigarette 8.50
6205 AR>> >> COPY 2
621dev2=#
622dev2=#
623dev2=# --
624dev2=# -- Data for Name: article; Type: TABLE DATA; Schema: public; Owner: postgres
625dev2=# --
626dev2=#
627dev2=# COPY article (id, numeroarticle, designation, prixunitaire) FROM stdin;
628Enter data to be copied followed by a newline.
629End with a backslash and a period on a line by itself, or an EOF signal.
630>> 1 4 Biere castel 2.50
6312 5 Jus orange 1.50l 2.50
6323 6 Stylo 2.50
6334 ART00010 Cigarette 8.50
6345 AR>> >> >> >> T00011 Gomme 2.50
6356 ART00012 Cahier 2.50
636\.
637
638
639--
640-- Name: article_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
641--
642
643SELECT pg_catalog.setval('article_id_seq', 6, true);
644
645
646--
647-- Data for Name: client; Type: TABLE DATA; Schema: public; Owner: postgres
648--
649
650COPY client (id, numerotiers, nomtiers, adressetiers) FROM stdin;
6517 CLT000500 Paul Paris
6528 CLT000501 Claude Clisson
6539 CLT000502 Robert Rennes
65412 CLT000503 Georges Rennes
655\.
656
657
658--
659-- Data for Name: commande; Type: TABLE DATA; Schema: public; Owner: postgres
660--
661
662COPY commande (id, numerocommande, datecommande, tiers_id, typecommande) FROM stdin;
663\.
664
665
666--
667-- Name: commande_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
668--
669
670SELECT pg_catalog.setval('commande_id_seq', 5, true);
671
672
673--
674-- Data for Name: fournisseur; Type: TABLE DATA; Schema: public; Owner: postgres
675--
676
677COPY fournisseur (id, numerotiers, nomtiers, adressetiers) FROM stdin;
67810 FRS000050 LeClerc Paris
67911 FRS000051 AuChan Clisson
68013 FR>> >> COPY 6
681dev2=#
682dev2=#
683dev2=# --
684dev2=# -- Name: article_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
685dev2=# --
686dev2=#
687dev2=# SELECT pg_catalog.setval('article_id_seq', 6, true);
688 setval
689--------
690 6
691(1 row)
692
693dev2=#
694dev2=#
695dev2=# --
696dev2=# -- Data for Name: client; Type: TABLE DATA; Schema: public; Owner: postgres
697dev2=# --
698dev2=#
699dev2=# COPY client (id, numerotiers, nomtiers, adressetiers) FROM stdin;
700Enter data to be copied followed by a newline.
701End with a backslash and a period on a line by itself, or an EOF signal.
702>> 7 CLT000500 Paul Paris
7038 CLT000501 Claude Clisson
7049 CLT000502 Robert Rennes
70512 CLT000503 Georges Rennes
706\.
707
708
709--
710-- Data for Name: commande; Type: TABLE DATA; Schema: public; Owner: postgres
711--
712
713COPY commande (id, numerocommande, datecommande, tiers_id, typecommande) FROM stdin;
714\.
715
716
717--
718-- Name: commande_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
719--
720
721SELECT pg_catalog.setval('commande_id_seq', 5, true);
722
723
724--
725-- Data for Name: fournisseur; Type: TABLE DATA; Schema: public; Owner: postgres
726--
727
728COPY fournisseur (id, numerotiers, nomtiers, adressetiers) FROM stdin;
72910 FRS000050 LeClerc Paris
73011 FRS000051 AuChan Clisson
73113 FRS000052 Casino Clisson
732\.
733
734
735--
736-- Name: >> >> >> >> COPY 4
737dev2=#
738dev2=#
739dev2=# --
740dev2=# -- Data for Name: commande; Type: TABLE DATA; Schema: public; Owner: postgres
741dev2=# --
742dev2=#
743dev2=# COPY commande (id, numerocommande, datecommande, tiers_id, typecommande) FROM stdin;
744Enter data to be copied followed by a newline.
745End with a backslash and a period on a line by itself, or an EOF signal.
746>> \.
747
748
749--
750-- Name: commande_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
751--
752
753SELECT pg_catalog.setval('commande_id_seq', 5, true);
754
755
756--
757-- Data for Name: fournisseur; Type: TABLE DATA; Schema: public; Owner: postgres
758--
759
760COPY fournisseur (id, numerotiers, nomtiers, adressetiers) FROM stdin;
76110 FRS000050 LeClerc Paris
76211 FRS000051 AuChan Clisson
76313 FRS000052 Casino Clisson
764\.
765
766
767--
768-- Name: COPY 0
769dev2=#
770dev2=#
771dev2=# --
772dev2=# -- Name: commande_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
773dev2=# --
774dev2=#
775dev2=# SELECT pg_catalog.setval('commande_id_seq', 5, true);
776 setval
777--------
778 5
779(1 row)
780
781dev2=#
782dev2=#
783dev2=# --
784dev2=# -- Data for Name: fournisseur; Type: TABLE DATA; Schema: public; Owner: postgres
785dev2=# --
786dev2=#
787dev2=# COPY fournisseur (id, numerotiers, nomtiers, adressetiers) FROM stdin;
788Enter data to be copied followed by a newline.
789End with a backslash and a period on a line by itself, or an EOF signal.
790>> 10 FRS000050 LeClerc Paris
79111 FRS000051 AuChan Clisson
79213 FRS000052 Casino Clisson
793\.
794
795
796--
797-- Name: >> >> >> COPY 3
798dev2=#
799dev2=#
800dev2=# --
801dev2=# -- Name: seq_numero; Type: SEQUENCE SET; Schema: public; Owner: postgres
802dev2=# --
803dev2=#
804dev2=# SELECT pg_catalog.setval('seq_numero', 57, true);
805 setval
806--------
807 57
808(1 row)
809
810dev2=#
811dev2=#
812dev2=# --
813dev2=# -- Name: seq_numero_appro; Type: SEQUENCE SET; Schema: public; Owner: postgres
814dev2=# --
815dev2=#
816dev2=# SELECT pg_catalog.setval('seq_numero_appro', 103, true);
817 setval
818--------
819 103
820(1 row)
821
822dev2=#
823dev2=#
824dev2=# --
825dev2=# -- Name: seq_numero_article; Type: SEQUENCE SET; Schema: public; Owner: postgres
826dev2=# --
827dev2=#
828dev2=# SELECT pg_catalog.setval('seq_numero_article', 12, true);
829 setval
830--------
831 12
832(1 row)
833
834dev2=#
835dev2=#
836dev2=# --
837dev2=# -- Name: seq_numero_client; Type: SEQUENCE SET; Schema: public; Owner: postgres
838dev2=# --
839dev2=#
840dev2=# SELECT pg_catalog.setval('seq_numero_client', 503, true);
841 setval
842--------
843 503
844(1 row)
845
846dev2=#
847dev2=#
848dev2=# --
849dev2=# -- Name: seq_numero_frs; Type: SEQUENCE SET; Schema: public; Owner: postgres
850dev2=# --
851dev2=#
852dev2=# SELECT pg_catalog.setval('seq_numero_frs', 52, true);
853 setval
854--------
855 52
856(1 row)
857
858dev2=#
859dev2=#
860dev2=# --
861dev2=# -- Name: seq_numero_tiers; Type: SEQUENCE SET; Schema: public; Owner: postgres
862dev2=# --
863dev2=#
864dev2=# SELECT pg_catalog.setval('seq_numero_tiers', 200, true);
865 setval
866--------
867 200
868(1 row)
869
870dev2=#
871dev2=#
872dev2=# --
873dev2=# -- Data for Name: tiers; Type: TABLE DATA; Schema: public; Owner: postgres
874dev2=# --
875dev2=#
876dev2=# COPY tiers (id, numerotiers, nomtiers, adressetiers) FROM stdin;
877Enter data to be copied followed by a newline.
878End with a backslash and a period on a line by itself, or an EOF signal.
879>> \.
880
881
882--
883-- Name: tiers_id_seq;COPY 0
884dev2=#
885dev2=#
886dev2=# --
887dev2=# -- Name: tiers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
888dev2=# --
889dev2=#
890dev2=# SELECT pg_catalog.setval('tiers_id_seq', 14, true);
891 setval
892--------
893 14
894(1 row)
895
896dev2=#
897dev2=#
898dev2=# --
899dev2=# -- Name: article_numeroarticle_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
900dev2=# --
901dev2=#
902dev2=# ALTER TABLE ONLY article
903dev2-# ADD CONSTRAINT article_numeroarticle_key UNIQUE (numeroarticle);
904ALTER TABLE
905dev2=#
906dev2=#
907dev2=# --
908dev2=# -- Name: article_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
909dev2=# --
910dev2=#
911dev2=# ALTER TABLE ONLY article
912dev2-# ADD CONSTRAINT article_pkey PRIMARY KEY (id);
913ALTER TABLE
914dev2=#
915dev2=#
916dev2=# --
917dev2=# -- Name: commande_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
918dev2=# --
919dev2=#
920dev2=# ALTER TABLE ONLY commande
921dev2-# ADD CONSTRAINT commande_pkey PRIMARY KEY (id);
922ALTER TABLE
923dev2=#
924dev2=#
925dev2=# --
926dev2=# -- Name: fournisseur_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
927dev2=# --
928dev2=#
929dev2=# ALTER TABLE ONLY fournisseur
930dev2-# ADD CONSTRAINT fournisseur_pkey PRIMARY KEY (id);
931ALTER TABLE
932dev2=#
933dev2=#
934dev2=# --
935dev2=# -- Name: tiers_numerotiers_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
936dev2=# --
937dev2=#
938dev2=# ALTER TABLE ONLY tiers
939dev2-# ADD CONSTRAINT tiers_numerotiers_key UNIQUE (numerotiers);
940ALTER TABLE
941dev2=#
942dev2=#
943dev2=# --
944dev2=# -- Name: tiers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
945dev2=# --
946dev2=#
947dev2=# ALTER TABLE ONLY tiers
948dev2-# ADD CONSTRAINT tiers_pkey PRIMARY KEY (id);
949ALTER TABLE
950dev2=#
951dev2=#
952dev2=# --
953dev2=# -- Name: idx_numero_appro; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
954dev2=# --
955dev2=#
956dev2=# CREATE INDEX idx_numero_appro ON appro USING btree (numerocommande);
957CREATE INDEX
958dev2=#
959dev2=#
960dev2=# --
961dev2=# -- Name: idx_numero_client; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
962dev2=# --
963dev2=#
964dev2=# CREATE INDEX idx_numero_client ON client USING btree (numerotiers);
965CREATE INDEX
966dev2=#
967dev2=#
968dev2=# --
969dev2=# -- Name: idx_numero_frs; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
970dev2=# --
971dev2=#
972dev2=# CREATE INDEX idx_numero_frs ON fournisseur USING btree (numerotiers);
973CREATE INDEX
974dev2=#
975dev2=#
976dev2=# --
977dev2=# -- Name: idx_type_appro; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
978dev2=# --
979dev2=#
980dev2=# CREATE INDEX idx_type_appro ON appro USING btree (typecommande);
981CREATE INDEX
982dev2=#
983dev2=#
984dev2=# --
985dev2=# -- Name: appro_tiers_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
986dev2=# --
987dev2=#
988dev2=# ALTER TABLE ONLY appro
989dev2-# ADD CONSTRAINT appro_tiers_id_fkey FOREIGN KEY (tiers_id) REFERENCES fournisseur(id);
990ALTER TABLE
991dev2=#
992dev2=#
993dev2=# --
994dev2=# -- Name: public; Type: ACL; Schema: -; Owner: postgres
995dev2=# --
996dev2=#
997dev2=# REVOKE ALL ON SCHEMA public FROM PUBLIC;
998REVOKE
999dev2=# REVOKE ALL ON SCHEMA public FROM postgres;
1000REVOKE
1001dev2=# GRANT ALL ON SCHEMA public TO postgres;
1002GRANT
1003dev2=# GRANT ALL ON SCHEMA public TO PUBLIC;
1004GRANT
1005dev2=#
1006dev2=#
1007dev2=# --
1008dev2=# -- PostgreSQL database dump complete
1009dev2=# --
1010dev2=#
1011dev2=#
1012dev2=# \d
1013 List of relations
1014 Schema | Name | Type | Owner
1015--------+--------------------+----------+----------
1016 public | appro | table | postgres
1017 public | article | table | postgres
1018 public | article_id_seq | sequence | postgres
1019 public | client | table | postgres
1020 public | commande | table | postgres
1021 public | commande_id_seq | sequence | postgres
1022 public | fournisseur | table | postgres
1023 public | seq_numero | sequence | postgres
1024 public | seq_numero_appro | sequence | postgres
1025 public | seq_numero_article | sequence | postgres
1026 public | seq_numero_client | sequence | postgres
1027 public | seq_numero_frs | sequence | postgres
1028 public | seq_numero_tiers | sequence | postgres
1029 public | tiers | table | postgres
1030 public | tiers_id_seq | sequence | postgres
1031(15 rows)
1032
1033dev2=# pg_dump dev2
1034dev2-# ;
1035ERROR: syntax error at or near "pg_dump"
1036LINE 1: pg_dump dev2
1037 ^
1038dev2=# dump
1039dev2-# ;
1040ERROR: syntax error at or near "dump"
1041LINE 1: dump
1042 ^
1043dev2=# pg_dump dev2 > Desktop;
1044ERROR: syntax error at or near "pg_dump"
1045LINE 1: pg_dump dev2 > Desktop;
1046 ^
1047dev2=# \l
1048 List of databases
1049 Name | Owner | Encoding | Collate | Ctype | Access privileges
1050-----------+----------+----------+---------+-------+-----------------------
1051 dev2 | postgres | UTF8 | C | C |
1052 dev2$ | postgres | UTF8 | C | C |
1053 postgres | postgres | UTF8 | C | C |
1054 template0 | postgres | UTF8 | C | C | =c/postgres +
1055 | | | | | postgres=CTc/postgres
1056 template1 | postgres | UTF8 | C | C | =c/postgres +
1057 | | | | | postgres=CTc/postgres
1058(5 rows)
1059
1060dev2=# \c
1061You are now connected to database "dev2" as user "postgres".
1062dev2=# pg_dump dev2 > ~/Users/Desktop/;
1063ERROR: syntax error at or near "pg_dump"
1064LINE 1: pg_dump dev2 > ~/Users/Desktop/;
1065 ^
1066dev2=# pg_dump -U postgres development > dump.sql
1067dev2-# ;
1068ERROR: syntax error at or near "pg_dump"
1069LINE 1: pg_dump -U postgres development > dump.sql
1070 ^
1071dev2=# ERROR: syntax error at or near "pg_dump"
1072dev2-# LINE 1: pg_dump -U postgres development > dump.sql
1073dev2-# ERROR: syntax error at or near "pg_dump"
1074dev2-# LINE 1: pg_dump -U postgres development > dump.sql
1075dev2-# psql -U postgres development > dump.sql
1076dev2-# ;
1077ERROR: syntax error at or near "ERROR"
1078LINE 1: ERROR: syntax error at or near "pg_dump"
1079 ^
1080dev2=# psql -U postgres development > dump.sql;
1081ERROR: syntax error at or near "psql"
1082LINE 1: psql -U postgres development > dump.sql;
1083 ^
1084dev2=# pg_dump -U postgres development > dump.sql;
1085ERROR: syntax error at or near "pg_dump"
1086LINE 1: pg_dump -U postgres development > dump.sql;
1087 ^
1088dev2=# \! pg_dump -Fc -f D:\postgres.dump -U postgres postgres
1089Password:
1090pg_dump: [archiver (db)] connection to database "postgres" failed: FATAL: password authentication failed for user "postgres"
1091dev2=# \! pg_dump -Fc -f D:\postgres.dump -U postgres postgres
1092Password:
1093dev2=# ;
1094dev2=# \! pg_dump -Fc -f D:\postgres.dump -U postgres postgres;
1095Password:
1096dev2=# \! pg_dump -Fc -f /Users/cia/Downloads/postgres.dump -U postgres postgres;
1097Password:
1098dev2=#