dbs_printtab(1p) [debian man page]

DBS_PRINTTAB(1p)					User Contributed Perl Documentation					  DBS_PRINTTAB(1p)

NAME

       dbs_printtab - Prints SQL table data on standard output

DESCRIPTION

       dbs_printtab is an utility to print SQL table data on standard output. dbs_printtab asks for a password if necessary.

COMMAND LINE PARAMETERS

       Required command line parameters are the DBI driver ("Pg" for Postgres or "mysql" for MySQL), the database name and the table name. The
       fourth parameter is optionally and specifies the database user and/or the host where the database resides ("racke", "racke@linuxia.de" or
       "@linuxia.de").

COMMAND LINE OPTIONS

       -c=COLUMN[,COLUMN], --columns=COLUMN[,COLUMN]

       The output is restricted to the given COLUMN arguments.

       --sort=KEY[,KEY]

       The output is sorted by the KEY arguments.

BUGS

       msql is not fully supported.

AUTHOR

       Stefan Hornburg (Racke), racke@linuxia.de

SEE ALSO

       perl(1), DBIx::Easy(3)

perl v5.8.8							    2007-02-01							  DBS_PRINTTAB(1p)

SQL::Translator::Parser::PostgreSQL(3pm)		User Contributed Perl Documentation		  SQL::Translator::Parser::PostgreSQL(3pm)

NAME

       SQL::Translator::Parser::PostgreSQL - parser for PostgreSQL

SYNOPSIS

	 use SQL::Translator;
	 use SQL::Translator::Parser::PostgreSQL;

	 my $translator = SQL::Translator->new;
	 $translator->parser("SQL::Translator::Parser::PostgreSQL");

DESCRIPTION

       The grammar was started from the MySQL parsers.	Here is the description from PostgreSQL:

       Table: (http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createtable.html)

	 CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
	     { column_name data_type [ DEFAULT default_expr ]
		[ column_constraint [, ... ] ]
	     | table_constraint }  [, ... ]
	 )
	 [ INHERITS ( parent_table [, ... ] ) ]
	 [ WITH OIDS | WITHOUT OIDS ]

	 where column_constraint is:

	 [ CONSTRAINT constraint_name ]
	 { NOT NULL | NULL | UNIQUE | PRIMARY KEY |
	   CHECK (expression) |
	   REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
	     [ ON DELETE action ] [ ON UPDATE action ] }
	 [ DEFERRABLE | NOT DEFERRABLE ]
	 [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

	 and table_constraint is:

	 [ CONSTRAINT constraint_name ]
	 { UNIQUE ( column_name [, ... ] ) |
	   PRIMARY KEY ( column_name [, ... ] ) |
	   CHECK ( expression ) |
	   FOREIGN KEY ( column_name [, ... ] )
	    REFERENCES reftable [ ( refcolumn [, ... ] ) ]
	     [ MATCH FULL | MATCH PARTIAL ]
	     [ ON DELETE action ] [ ON UPDATE action ] }
	 [ DEFERRABLE | NOT DEFERRABLE ]
	 [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

       Index: (http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-createindex.html)

	 CREATE [ UNIQUE ] INDEX index_name ON table
	     [ USING acc_method ] ( column [ ops_name ] [, ...] )
	     [ WHERE predicate ]
	 CREATE [ UNIQUE ] INDEX index_name ON table
	     [ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
	     [ WHERE predicate ]

       Alter table:

	 ALTER TABLE [ ONLY ] table [ * ]
	     ADD [ COLUMN ] column type [ column_constraint [ ... ] ]
	 ALTER TABLE [ ONLY ] table [ * ]
	     ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
	 ALTER TABLE [ ONLY ] table [ * ]
	     ALTER [ COLUMN ] column SET STATISTICS integer
	 ALTER TABLE [ ONLY ] table [ * ]
	     RENAME [ COLUMN ] column TO newcolumn
	 ALTER TABLE table
	     RENAME TO new_table
	 ALTER TABLE table
	     ADD table_constraint_definition
	 ALTER TABLE [ ONLY ] table
		 DROP CONSTRAINT constraint { RESTRICT | CASCADE }
	 ALTER TABLE table
		 OWNER TO new_owner

       View table:

	   CREATE [ OR REPLACE ] VIEW view [ ( column name list ) ] AS SELECT query

AUTHORS

       Ken Y. Clark <kclark@cpan.org>, Allen Day <allenday@ucla.edu>.

SEE ALSO

       perl(1), Parse::RecDescent.

perl v5.14.2							    2012-05-01				  SQL::Translator::Parser::PostgreSQL(3pm)