PHP Classes

File: sql/test-postgresql.sql

Recommend this page to a friend!
  Classes of Kakhaber Kashmadze  >  DbUtils  >  sql/test-postgresql.sql  >  Download  
File: sql/test-postgresql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: DbUtils
Access and Manage MySQL, PostgreSQL or MS SQL
Author: By
Last change: error when type of sql is directly dumped
Date: 6 years ago
Size: 1,476 bytes
 

Contents

Class file image Download
--
-- PostgreSQL database dump
--

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: users; Type: TABLE; Schema: public; Owner: hi; Tablespace: 
--

CREATE TABLE users (
    id integer NOT NULL,
    lname character varying(255) NOT NULL,
    fname character varying(255) NOT NULL,
    email character varying(255),
    active boolean DEFAULT true
);


ALTER TABLE users OWNER TO hi;

--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: hi
--

INSERT INTO users VALUES (1, 'lname1', 'fname1', 'fname1@email.example', true);
INSERT INTO users VALUES (2, 'lname2', 'fname2', 'fname2@email.example', true);
INSERT INTO users VALUES (3, 'lname3', 'fname3', 'fname3@email.example', true);
INSERT INTO users VALUES (4, 'lname4', 'lname4', 'fname4@email.example', true);
INSERT INTO users VALUES (5, 'lname5', 'lname5', 'fname5@email.example', true);
INSERT INTO users VALUES (6, 'lname6', 'fname6', 'fname6@email.example', true);
INSERT INTO users VALUES (7, 'lname7', 'fname7', 'fname7@email.example', true);


--
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: hi; Tablespace: 
--

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- PostgreSQL database dump complete
--

For more information send a message to info at phpclasses dot org.