APGDIFF(1)APGDIFF(1)NAME
apgdiff - Another PostgreSQL Diff Tool
SYNOPSIS
Usage: apgdiff [options] <old_dump> <new_dump>
DESCRIPTION
Another PostgreSQL Diff Tool is a simple PostgreSQL diff tool that is useful for schema upgrades. The tool compares two schema dump files
and creates an SQL output file that is (after some hand-made modifications) suitable for upgrades of old schemata.
OPTIONS --version
displays apgdiff version
--add-defaults
adds DEFAULT ... in case new column has NOT NULL constraint but no default value (the default value is dropped later)
--add-transaction
adds START TRANSACTION and COMMIT TRANSACTION to the generated diff file
--ignore-function-whitespace
ignores multiple spaces and new lines when comparing content of functions
o WARNING: this may cause functions to appear to be same in cases they are not, so use this feature only if you know what you are
doing
--ignore-start-with
ignores START WITH modifications on SEQUENCEs (default is not to ignore these changes)
--in-charset-name <charset>
charset that should be used for reading input files (standard charset name supported by Java, default is UTF-8)
--out-charset-name <charset>
charset that should be used for writing output (standard charset name supported by Java, default is UTF-8)
--output-ignored-statements
outputs information about DDL statements that apgdiff ignores at this moment (it will not output any SELECT, INSERT, UPDATE and/or
DELETE statements)
--list-charsets
lists all supported charsets
AUTHOR
Miroslav ulc <miroslav.sulc@startnet.cz>. This manual page was written by Christoph Berg <myon@debian.org> for the Debian system (but may
be used by others).
10/31/2010 APGDIFF(1)
Check Out this Related Man Page
START TRANSACTION(7) SQL Commands START TRANSACTION(7)NAME
START TRANSACTION - start a transaction block
SYNOPSIS
START TRANSACTION [ transaction_mode [, ...] ]
where transaction_mode is one of:
ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED }
READ WRITE | READ ONLY
DESCRIPTION
This command begins a new transaction block. If the isolation level or read/write mode is specified, the new transaction has those charac-
teristics, as if SET TRANSACTION [set_transaction(7)] was executed. This is the same as the BEGIN [begin(7)] command.
PARAMETERS
Refer to SET TRANSACTION [set_transaction(7)] for information on the meaning of the parameters to this statement.
COMPATIBILITY
In the standard, it is not necessary to issue START TRANSACTION to start a transaction block: any SQL command implicitly begins a block.
PostgreSQL's behavior can be seen as implicitly issuing a COMMIT after each command that does not follow START TRANSACTION (or BEGIN), and
it is therefore often called ``autocommit''. Other relational database systems might offer an autocommit feature as a convenience.
The SQL standard requires commas between successive transaction_modes, but for historical reasons PostgreSQL allows the commas to be omit-
ted.
See also the compatibility section of SET TRANSACTION [set_transaction(7)].
SEE ALSO
BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)], SAVEPOINT [savepoint(7)], SET TRANSACTION [set_transaction(7)]
SQL - Language Statements 2010-05-14 START TRANSACTION(7)
Good Afternoon Guys:
we can use ls -l to find out the files and their modification time. however, how to list the files say which are modified 15 minutes before. we have find command which uses -mtime and -atime for modification and access timing. However, if we just be restricted to the current... (2 Replies)
i have two big file which have thousand of line.
i have to sort on two key fields then diff the file.
if the interger value of one of the column is less then or greater then 1 it should ignore it.
for example
File1
abc|7000|jhon|2.3
xyz|9000|sam|6.7
pqr|8000|kapi|4.6
File2... (11 Replies)
I need to send a HTML mail. I used <meta> tag for giving info about the charset. That is UTF-8. My question in here is,
How to avoid special character's in Java mail. Even though I set with setContent method with UTF-8 format, I get the special character rarely. I get special character like ???... (2 Replies)
Hi,
I need some advise on whether there is a better way of doing what I am currently planning to do. Perhaps I should be using arrays instead of re-directing output to files?
I need to use a tool/program named ADRCI provided by Oracle to remove trace files that it generates. Honestly it is... (1 Reply)
Dear Experts,
I need your help here. I have lot of teradata DDL's as follows, i want to extract field names , field attributes and NOT NULL information from DDL.Could you please help here.
Sample DDL:
CREATE MULTISET TABLE APS_CALL_IN_PICKUP_CANCELED ,NO FALLBACK ,
NO BEFORE... (2 Replies)
Hi all,
am running the following code on a RHEL 6.6 box to list which charsets are loaded and which are available:
#!/usr/bin/perl -w
use strict;
use Encode;
my @list = Encode->encodings();
my @all_encodings = Encode->encodings(":all");
print "@list\n\n";
print "@all_encodings\n";
... (3 Replies)