pdf viewer in asp net c# : Add image pdf software application dll windows html asp.net web forms postgresql-9.4-A496-part3023

Chapter 34. The Information Schema
Name
Data Type
Description
maximum_value
character_data
The maximum value of the
sequence
increment
character_data
The increment of the sequence
cycle_option
yes_or_no
YES
if the sequence cycles, else
NO
Note that in accordance with the SQL standard, the start, minimum, maximum, and incrementvalues
are returned as character strings.
34.43.
sql_features
The table
sql_features
contains informationabout which formal features definedin the SQL stan-
dard are supported by PostgreSQL. This is the same information that is presented in Appendix D.
There you can also find some additional background information.
Table 34-41.
sql_features
Columns
Name
Data Type
Description
feature_id
character_data
Identifier string of the feature
feature_name
character_data
Descriptive name of the feature
sub_feature_id
character_data
Identifier string of the
subfeature, or a zero-length
string if not a subfeature
sub_feature_name
character_data
Descriptive name of the
subfeature, or a zero-length
string if not a subfeature
is_supported
yes_or_no
YES
if the feature is fully
supported by the current version
of PostgreSQL,
NO
if not
is_verified_by
character_data
Always null, since the
PostgreSQL development group
does not perform formal testing
of feature conformance
comments
character_data
Possibly a comment about the
supported status of the feature
34.44.
sql_implementation_info
The table
sql_implementation_info
contains information about various aspects that are left
implementation-defined by the SQL standard. This information is primarily intended for use in the
context of the ODBC interface; users of other interfaces will probably find this information to be of
little use. For this reason, theindividual implementationinformation items arenotdescribed here;you
will find them in the description of the ODBC interface.
888
Add image pdf - insert images into PDF in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Sample C# code to add image, picture, logo or digital photo into PDF document page using PDF page editor control
how to add photo to pdf in preview; how to add image to pdf form
Add image pdf - VB.NET PDF insert image library: insert images into PDF in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Guide VB.NET Programmers How to Add Images in PDF Document
add image to pdf java; how to add image to pdf document
Chapter 34. The Information Schema
Table 34-42.
sql_implementation_info
Columns
Name
Data Type
Description
implementation_info_id
character_data
Identifier string of the
implementation information
item
implementation_info_name
character_data
Descriptive name of the
implementation information
item
integer_value
cardinal_number
Value of the implementation
information item, or null if the
value is contained in the
column
character_value
character_value
character_data
Value of the implementation
information item, or null if the
value is contained in the
column
integer_value
comments
character_data
Possibly a comment pertaining
to the implementation
information item
34.45.
sql_languages
The table
sql_languages
contains one row for each SQL language binding that is supported by
PostgreSQL. PostgreSQL supports direct SQL and embedded SQL in C; that is all you will learn
from this table.
This table was removed from the SQL standard in SQL:2008, so there are no entries referring to
standards later than SQL:2003.
Table 34-43.
sql_languages
Columns
Name
Data Type
Description
sql_language_source
character_data
The name of the source of the
language definition; always
ISO
9075
,that is, the SQL standard
sql_language_year
character_data
The year the standard
referencedin
sql_language_source
was
approved.
sql_language_conformance
character_data
The standard conformance
level for the language binding.
For ISO 9075:2003 this is
always
CORE
.
sql_language_integrity
character_data
Always null (This value is
relevant to an earlier version of
the SQL standard.)
889
C# PDF Image Extract Library: Select, copy, paste PDF images in C#
Get image information, such as its location, zonal information, metadata, and so on. Able to edit, add, delete, move, and output PDF document image.
add image pdf acrobat; add image to pdf form
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
DLLs for PDF Image Extraction in VB.NET. In order to run the sample code, the following steps would be necessary. Add necessary references:
how to add a picture to a pdf document; add multiple jpg to pdf
Chapter 34. The Information Schema
Name
Data Type
Description
sql_language_implementation
character_data
Always null
sql_language_binding_style
character_data
The language binding style,
either
DIRECT
or
EMBEDDED
sql_language_programming_language
character_data
The programming language, if
the binding style is
EMBEDDED
,
else null. PostgreSQL only
supports the language C.
34.46.
sql_packages
The table
sql_packages
contains information about which feature packages defined in the SQL
standard are supported by PostgreSQL. Refer to Appendix D for background information on feature
packages.
Table 34-44.
sql_packages
Columns
Name
Data Type
Description
feature_id
character_data
Identifier string of the package
feature_name
character_data
Descriptive name of the
package
is_supported
yes_or_no
YES
if the package is fully
supported by the current version
of PostgreSQL,
NO
if not
is_verified_by
character_data
Always null, since the
PostgreSQL development group
does not perform formal testing
of feature conformance
comments
character_data
Possibly a comment about the
supported status of the package
34.47.
sql_parts
The table
sql_parts
contains information about which of the several parts of the SQL standard are
supported by PostgreSQL.
Table 34-45.
sql_parts
Columns
Name
Data Type
Description
feature_id
character_data
An identifier string containing
the number of the part
feature_name
character_data
Descriptive name of the part
890
VB.NET PDF Password Library: add, remove, edit PDF file password
VB: Add Password to PDF with Permission Settings Applied. This VB.NET example shows how to add PDF file password with access permission setting.
add photo to pdf in preview; add a picture to a pdf document
C# PDF Password Library: add, remove, edit PDF file password in C#
C# Sample Code: Add Password to PDF with Permission Settings Applied in C#.NET. This example shows how to add PDF file password with access permission setting.
add jpeg to pdf; add picture to pdf form
Chapter 34. The Information Schema
Name
Data Type
Description
is_supported
yes_or_no
YES
if the part is fully
supported by the current version
of PostgreSQL,
NO
if not
is_verified_by
character_data
Always null, since the
PostgreSQL development group
does not perform formal testing
of feature conformance
comments
character_data
Possibly a comment about the
supported status of the part
34.48.
sql_sizing
The table
sql_sizing
contains information about various size limits and maximum values in Post-
greSQL. This informationis primarily intendedfor use in the contextof the ODBC interface; users of
other interfaces will probably find this information to be of little use. For this reason, the individual
sizing items are not described here; you will find them in the description of the ODBC interface.
Table 34-46.
sql_sizing
Columns
Name
Data Type
Description
sizing_id
cardinal_number
Identifier of the sizing item
sizing_name
character_data
Descriptive name of the sizing
item
supported_value
cardinal_number
Value of the sizing item, or 0 if
the size is unlimited or cannot
be determined, or null if the
features for which the sizing
item is applicable are not
supported
comments
character_data
Possibly a comment pertaining
to the sizing item
34.49.
sql_sizing_profiles
The table
sql_sizing_profiles
contains information about the
sql_sizing
values that are re-
quired by various profiles of the SQL standard. PostgreSQL does not track any SQL profiles, so this
table is empty.
Table 34-47.
sql_sizing_profiles
Columns
Name
Data Type
Description
sizing_id
cardinal_number
Identifier of the sizing item
sizing_name
character_data
Descriptive name of the sizing
item
891
C# Create PDF from images Library to convert Jpeg, png images to
List<Bitmap> images = new List<Bitmap>(); images.Add(new Bitmap(Program.RootPath + "\\" 1.gif")); / Build a PDF document with GIF image.
adding an image to a pdf file; adding image to pdf in preview
C# PDF Sticky Note Library: add, delete, update PDF note in C#.net
C#.NET PDF SDK - Add Sticky Note to PDF Page in C#.NET. Able to add notes to PDF using C# source code in Visual Studio .NET framework.
add an image to a pdf in preview; add image to pdf file acrobat
Chapter 34. The Information Schema
Name
Data Type
Description
profile_id
character_data
Identifier string of a profile
required_value
cardinal_number
The value required by the SQL
profile for the sizing item, or 0
if the profile places no limit on
the sizing item, or null if the
profile does not require any of
the features for whichthe sizing
item is applicable
comments
character_data
Possibly a comment pertaining
to the sizing item within the
profile
34.50.
table_constraints
The view
table_constraints
containsallconstraintsbelongingtotables thatthecurrent user owns
or has some privilege other than
SELECT
on.
Table 34-48.
table_constraints
Columns
Name
Data Type
Description
constraint_catalog
sql_identifier
Name of the database that
contains the constraint (always
the current database)
constraint_schema
sql_identifier
Name of the schema that
contains the constraint
constraint_name
sql_identifier
Name of the constraint
table_catalog
sql_identifier
Name of the database that
contains the table (always the
current database)
table_schema
sql_identifier
Name of the schema that
contains the table
table_name
sql_identifier
Name of the table
constraint_type
character_data
Type of the constraint:
CHECK
,
FOREIGN KEY
,
PRIMARY KEY
,
or
UNIQUE
is_deferrable
yes_or_no
YES
if the constraint is
deferrable,
NO
if not
initially_deferred
yes_or_no
YES
if the constraint is
deferrable and initially
deferred,
NO
if not
34.51.
table_privileges
The view
table_privileges
identifies all privileges granted on tables or views to a currently en-
892
C# PDF remove image library: remove, delete images from PDF in C#.
C# Read: PDF Image Extract; C# Write: Insert text into PDF; C# Write: Add Image to PDF; Remove Image from PDF Page Using C#. Add necessary references:
add image to pdf in preview; add photo to pdf
VB.NET PDF remove image library: remove, delete images from PDF in
C# Read: PDF Image Extract; C# Write: Insert text into PDF; C# Write: Add Image to PDF; VB.NET: Remove Image from PDF Page. Add necessary references:
add photo to pdf for; add image to pdf reader
Chapter 34. The Information Schema
abledrole or by a currently enabledrole. There is one rowfor each combination of table, grantor, and
grantee.
Table 34-49.
table_privileges
Columns
Name
Data Type
Description
grantor
sql_identifier
Name of the role that granted
the privilege
grantee
sql_identifier
Name of the role that the
privilege was granted to
table_catalog
sql_identifier
Name of the database that
contains the table (always the
current database)
table_schema
sql_identifier
Name of the schema that
contains the table
table_name
sql_identifier
Name of the table
privilege_type
character_data
Type of the privilege:
SELECT
,
INSERT
,
UPDATE
,
DELETE
,
TRUNCATE
,
REFERENCES
,or
TRIGGER
is_grantable
yes_or_no
YES
if the privilege is grantable,
NO
if not
with_hierarchy
yes_or_no
In the SQL standard,
WITH
HIERARCHY OPTION
is a
separate (sub-)privilege
allowing certain operations on
table inheritance hierarchies. In
PostgreSQL, this is included in
the
SELECT
privilege, sothis
column shows
YES
if the
privilege is
SELECT
,else
NO
.
34.52.
tables
The view
tables
contains all tables and views defined in the current database. Only those tables
and views are shown that the current user has access to (by way of being the owner or having some
privilege).
Table 34-50.
tables
Columns
Name
Data Type
Description
table_catalog
sql_identifier
Name of the database that
contains the table (always the
current database)
table_schema
sql_identifier
Name of the schema that
contains the table
table_name
sql_identifier
Name of the table
893
Chapter 34. The Information Schema
Name
Data Type
Description
table_type
character_data
Type of the table:
BASE
TABLE
for a persistent base
table (the normal table type),
VIEW
for a view,
FOREIGN
TABLE
for a foreign table, or
LOCAL TEMPORARY
for a
temporary table
self_referencing_column_name
sql_identifier
Applies to a feature not
available in PostgreSQL
reference_generation
character_data
Applies to a feature not
available in PostgreSQL
user_defined_type_catalog
sql_identifier
If the table is a typed table, the
name of the database that
contains the underlying data
type (always the current
database), else null.
user_defined_type_schema
sql_identifier
If the table is a typed table, the
name of the schema that
contains the underlying data
type, else null.
user_defined_type_name
sql_identifier
If the table is a typed table, the
name of the underlying data
type, else null.
is_insertable_into
yes_or_no
YES
if the table is insertable
into,
NO
if not (Base tables are
always insertable into, views
not necessarily.)
is_typed
yes_or_no
YES
if the table is a typed table,
NO
if not
commit_action
character_data
Not yet implemented
34.53.
triggered_update_columns
For triggers in the current database that specify a column list (like
UPDATE OF column1,
column2
), the view
triggered_update_columns
identifies these columns. Triggers that do not
specify a column list are not included in this view. Only those columns are shown that the current
user owns or has some privilege other than
SELECT
on.
Table 34-51.
triggered_update_columns
Columns
Name
Data Type
Description
trigger_catalog
sql_identifier
Name of the database that
contains the trigger (always the
current database)
trigger_schema
sql_identifier
Name of the schema that
contains the trigger
894
Chapter 34. The Information Schema
Name
Data Type
Description
trigger_name
sql_identifier
Name of the trigger
event_object_catalog
sql_identifier
Name of the database that
contains the table that the
trigger is defined on (always the
current database)
event_object_schema
sql_identifier
Name of the schema that
contains the table that the
trigger is defined on
event_object_table
sql_identifier
Name of the table that the
trigger is defined on
event_object_column
sql_identifier
Name of the column that the
trigger is defined on
34.54.
triggers
The view
triggers
contains all triggers defined in the current database on tables and views that the
current user owns or has some privilege other than
SELECT
on.
Table 34-52.
triggers
Columns
Name
Data Type
Description
trigger_catalog
sql_identifier
Name of the database that
contains the trigger (always the
current database)
trigger_schema
sql_identifier
Name of the schema that
contains the trigger
trigger_name
sql_identifier
Name of the trigger
event_manipulation
character_data
Event that fires the trigger
(
INSERT
,
UPDATE
,or
DELETE
)
event_object_catalog
sql_identifier
Name of the database that
contains the table that the
trigger is defined on (always the
current database)
event_object_schema
sql_identifier
Name of the schema that
contains the table that the
trigger is defined on
event_object_table
sql_identifier
Name of the table that the
trigger is defined on
action_order
cardinal_number
Not yet implemented
action_condition
character_data
WHEN
condition of the trigger,
null if none (also null if the
table is not owned by a
currently enabled role)
895
Chapter 34. The Information Schema
Name
Data Type
Description
action_statement
character_data
Statement that is executed by
the trigger (currently always
EXECUTE PROCEDURE
function
(...)
)
action_orientation
character_data
Identifies whether the trigger
fires once for each processed
row or once for each statement
(
ROW
or
STATEMENT
)
action_timing
character_data
Time at which the trigger fires
(
BEFORE
,
AFTER
,or
INSTEAD
OF
)
action_reference_old_table
sql_identifier
Applies to a feature not
available in PostgreSQL
action_reference_new_table
sql_identifier
Applies to a feature not
available in PostgreSQL
action_reference_old_row
sql_identifier
Applies to a feature not
available in PostgreSQL
action_reference_new_row
sql_identifier
Applies to a feature not
available in PostgreSQL
created
time_stamp
Applies to a feature not
available in PostgreSQL
Triggers in PostgreSQL have two incompatibilities with the SQL standard that affect the
representation in the information schema. First, trigger names are local to each table in PostgreSQL,
rather than being independent schema objects. Therefore there can be duplicate trigger names
defined in one schema, so long as they belong to different tables. (
trigger_catalog
and
trigger_schema
are really the values pertaining to the table that the trigger is defined on.) Second,
triggers can be defined to fire on multiple events in PostgreSQL (e.g.,
ON INSERT OR UPDATE
),
whereas the SQL standard only allows one. If a trigger is defined to fire on multiple events, it is
represented as multiple rows in the information schema, one for each type of event. As a consequence
of these two issues, the primary key of the view
triggers
is really
(trigger_catalog,
trigger_schema, event_object_table, trigger_name, event_manipulation)
instead
of
(trigger_catalog, trigger_schema, trigger_name)
,which is what the SQL standard
specifies. Nonetheless, if you define your triggers in a manner that conforms with the SQL standard
(trigger names unique in the schema and only one event type per trigger), this will not affect you.
Note:
Prior
to
PostgreSQL
9.1,
this
view’s
columns
action_timing
,
action_reference_old_table
,
action_reference_new_table
,
action_reference_old_row
,
and
action_reference_new_row
were
named
condition_timing
,
condition_reference_old_table
,
condition_reference_new_table
,
condition_reference_old_row
, and
condition_reference_new_row
respectively. That was
how they were named in the SQL:1999 standard. The new naming conforms to SQL:2003 and
later.
896
Chapter 34. The Information Schema
34.55.
udt_privileges
The view
udt_privileges
identifies
USAGE
privileges granted on user-defined types to a currently
enabled role or bya currently enabledrole. There is one row for each combination of column, grantor,
and grantee. This view shows only composite types (see under Section 34.57 for why); see Section
34.56 for domain privileges.
Table 34-53.
udt_privileges
Columns
Name
Data Type
Description
grantor
sql_identifier
Name of the role that granted
the privilege
grantee
sql_identifier
Name of the role that the
privilege was granted to
udt_catalog
sql_identifier
Name of the database
containing the type (always the
current database)
udt_schema
sql_identifier
Name of the schema containing
the type
udt_name
sql_identifier
Name of the type
privilege_type
character_data
Always
TYPE USAGE
is_grantable
yes_or_no
YES
if the privilege is grantable,
NO
if not
34.56.
usage_privileges
The view
usage_privileges
identifies
USAGE
privileges granted on various kinds of objects to a
currently enabled role or by a currently enabled role. In PostgreSQL, this currently applies to col-
lations, domains, foreign-data wrappers, foreign servers, and sequences. There is one row for each
combination of object, grantor, and grantee.
Since collations do not have real privileges in PostgreSQL, this view shows implicit non-grantable
USAGE
privileges granted by the owner to
PUBLIC
for all collations. The other object types, however,
showreal privileges.
In PostgreSQL, sequences also support
SELECT
and
UPDATE
privileges in addition to the
USAGE
privilege. These are nonstandard and therefore not visible in the information schema.
Table 34-54.
usage_privileges
Columns
Name
Data Type
Description
grantor
sql_identifier
Name of the role that granted
the privilege
grantee
sql_identifier
Name of the role that the
privilege was granted to
object_catalog
sql_identifier
Name of the database
containing the object (always
the current database)
897
Documents you may be interested
Documents you may be interested