SPI_GETTYPE(3) PostgreSQL 9.2.7 Documentation SPI_GETTYPE(3)NAME
SPI_gettype - return the data type name of the specified column
SYNOPSIS
char * SPI_gettype(TupleDesc rowdesc, int colnumber)
DESCRIPTION
SPI_gettype returns a copy of the data type name of the specified column. (You can use pfree to release the copy of the name when you don't
need it anymore.)
ARGUMENTS
TupleDesc rowdesc
input row description
int colnumber
column number (count starts at 1)
RETURN VALUE
The data type name of the specified column, or NULL on error. SPI_result is set to SPI_ERROR_NOATTRIBUTE on error.
PostgreSQL 9.2.7 2014-02-17 SPI_GETTYPE(3)
Check Out this Related Man Page
Alzabo::PostgreSQL(3pm) User Contributed Perl Documentation Alzabo::PostgreSQL(3pm)NAME
Alzabo::PostgreSQL - Alzabo and PostgreSQL
DESCRIPTION
This documentation is about what special support Alzabo has for PostgreSQL, as well as what is lacking.
Postgres support is based on the 7.3.x version of Postgres. Alzabo should work with the 7.1 and 7.2 series, and may even work with the 7.0
series.
Mixed-case Table or Column Names
By default, Postgres treats table and column names case-insensitively. Because of this, Alzabo always quotes these names when generating
DDL SQL. If you are using tables or columns that contain upper-case characters, you should always call "$schema->set_quote_identifiers(1)"
as soon as you load your schema object. Otherwise, any method which generates DML SQL will fail.
Reverse Engineering
o Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the
sequence was created as a result of making a column's type SERIAL.
This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change.
Transactions
o Transactions are fully supported with Postgres.
Outer joins
o Left and right outer joins are supported.
o Full outer joins are not supported.
Constraints
Column constraints can be specified as column attributes. Table constraints can be specified as table attributes.
Foreign key constraints are generated automatically based on the relationships defined by your schema.
perl v5.8.8 2007-12-23 Alzabo::PostgreSQL(3pm)
Hi everyone,
I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX.
Ok onto business, my questions are-:
Was/Is UNIX ever an open source operating system ?
If UNIX was... (21 Replies)
Hello and thanks in advance for any help anyone can offer me
I'm trying to learn the find command and thought I was understanding it... Apparently I was wrong. I was doing compound searches and I started getting weird results with the -size test. I was trying to do a search on a 1G file owned by... (14 Replies)
hi all,
i have installed quota on my centos 7 machine and its what im after (setting size limit on users, so they cant fill the hard drive)
i want to now make this part of my create user script for my sftp server so i want to do a echo and a read command so i capture the limit they enter... (0 Replies)
Hi everybody,
Which Unix base OS have best performance for HOST virtualization?
I tested SmartOS but it needs another OS to connect remotely!
Thanks in advance. (11 Replies)
Hi All,
I need to write a shell script which opens a file and increments the version(text) within the file every time the script runs. For example:
$ cat docker_file.yml
version: '3.1'
services:
ui:
image: repo-srv.dev.io:5000/facebook/ui:0.0.2-QA1
$
So, I would like... (6 Replies)
Dear Team
We use DB2 v10.5 and using DBArtisan tool
Can someone please guide how to convert digits to binary numbers using db2 feature.
Ex> for number 9 , binary should be 1001 ( 8+1)
Any help appreciated. Thanks (2 Replies)
hi folks,
how to using tar with exclude directory and compress it using tar.Z
i only know how to exclude dir only with this command below:
tar -cvf /varios/restore/test.tar -X excludefile.txt /jfma/test1/
how to compress it using 1 command?
Thanx
Please use CODE tags as... (6 Replies)
Quite an obscure question I think.
We have a rebuild process for remote sites that allows us to PXE rebuild a till (actually a PC with a touch screen and various fancy bits) running CentOS. The current CentOS5 tills work just fine with a tar image restore and some personalisation. Sadly,... (4 Replies)
Hello All,
I had recently learnt a bit of Docker(which provides containerization process).
Here are some of my learning points from it.
Let us start first with very basic question:
What is Docker:
Docker is a platform for sysadmins and developers to DEPLOY, DEVELOP and RUN applications ... (7 Replies)
What is the point of this? Whenever I close my shell it appends to the history file without adding this. I have never seen it overwrite my history file.
# When the shell exits, append to the history file instead of overwriting it
shopt -s histappend (3 Replies)
Hello... And thanks in advance for any help anyone can offer me
I was trying to work out the differences between displaying modify, access, and change times with the 'ls' command. Everything seems in order when I look at files, but the access time on a directory doesn't seem to change when I... (4 Replies)
Hello everyone,
I am having an issue here with CentOS release 6.6 (Final) that shows all of the space used up, but I can't tell where the space went.
Seemingly I am using up 100%, according to
df -h
Filesystem Size Used Avail Use% Mounted on... (27 Replies)
I'm trying to use a bash script for a psych experiment that involves listening to sound files and responding. If I have something like the code below, how can I make sure that a key press is assigned to RESPONSE only after the second echo statement?
for i in 1 2 3; do
echo "Ready?"
sleep 2
... (10 Replies)
After the success of the jq - tool for parsing and manipulating JSON-Data someone wrote a tool called yq, which aims to be the same for YAML, what jq is for JSON. Seems to work fine. I'll definitely give it a chance in future.
Example YAML-File:
--- !ruby/object:Puppet::Node::Facts
... (1 Reply)
Dear All,
I am very pleased to announce that Dave Munro (gull04) is joining the Moderation Team, after being a very valuable member of UNIX.com for 15+ years.
Dave is an IT Consultant with 30 years of experience this year, has worked in many of the industry vertical market segments and has... (6 Replies)