Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

alter_large_object(7) [centos man page]

ALTER LARGE 
OBJECT(7) PostgreSQL 9.2.7 Documentation ALTER LARGE OBJECT(7) NAME
ALTER_LARGE_OBJECT - change the definition of a large object SYNOPSIS
ALTER LARGE OBJECT large_object_oid OWNER TO new_owner DESCRIPTION
ALTER LARGE OBJECT changes the definition of a large object. The only functionality is to assign a new owner. You must be superuser or owner of the large object to use ALTER LARGE OBJECT. PARAMETERS
large_object_oid OID of the large object to be altered new_owner The new owner of the large object COMPATIBILITY
There is no ALTER LARGE OBJECT statement in the SQL standard. SEE ALSO
Chapter 32, Large Objects, in the documentation PostgreSQL 9.2.7 2014-02-17 ALTER LARGE OBJECT(7)

Check Out this Related Man Page

ALTER 
TYPE(7) SQL Commands ALTER TYPE(7) NAME
ALTER TYPE - change the definition of a type SYNOPSIS
ALTER TYPE name RENAME TO new_name ALTER TYPE name OWNER TO new_owner ALTER TYPE name SET SCHEMA new_schema DESCRIPTION
ALTER TYPE changes the definition of an existing type. You must own the type to use ALTER TYPE. To change the schema of a type, you must also have CREATE privilege on the new schema. To alter the owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the type's schema. (These restrictions enforce that altering the owner doesn't do anything you couldn't do by dropping and recreating the type. How- ever, a superuser can alter ownership of any type anyway.) PARAMETERS
name The name (possibly schema-qualified) of an existing type to alter. new_name The new name for the type. new_owner The user name of the new owner of the type. new_schema The new schema for the type. EXAMPLES
To rename a data type: ALTER TYPE electronic_mail RENAME TO email; To change the owner of the type email to joe: ALTER TYPE email OWNER TO joe; To change the schema of the type email to customers: ALTER TYPE email SET SCHEMA customers; COMPATIBILITY
There is no ALTER TYPE statement in the SQL standard. SQL - Language Statements 2010-05-14 ALTER TYPE(7)
Man Page

15 More Discussions You Might Find Interesting

1. Fedora

Is UNIX an open source OS ?

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)
Discussion started by: sreyan32
21 Replies

2. UNIX for Beginners Questions & Answers

Weird 'find' results

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)
Discussion started by: bodisha
14 Replies

3. UNIX for Beginners Questions & Answers

Set hard block limit for user using quota

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)
Discussion started by: robertkwild
0 Replies

4. UNIX for Beginners Questions & Answers

Best performance UNIX just for HOST Virtualization?

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)
Discussion started by: mbzadegan
11 Replies

5. UNIX for Beginners Questions & Answers

How to increment version inside a file?

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)
Discussion started by: akshayupadhayay
6 Replies

6. Programming

DB2 convert digits to binary format

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)
Discussion started by: Perlbaby
2 Replies

7. UNIX for Advanced & Expert Users

Tar Command

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)
Discussion started by: only
6 Replies

8. UNIX for Advanced & Expert Users

CentOS7 restoring file capabilities

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)
Discussion started by: rbatte1
4 Replies

9. Docker

Docker learning Phase-I

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)
Discussion started by: RavinderSingh13
7 Replies

10. UNIX for Advanced & Expert Users

Shopt -s histappend

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)
Discussion started by: cokedude
3 Replies

11. UNIX for Beginners Questions & Answers

Unsure why access time on a directory change isn't changing

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)
Discussion started by: bodisha
4 Replies

12. UNIX for Beginners Questions & Answers

CentOS 6 ran out of space, need to reclaim it

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)
Discussion started by: DannyBoyCentOS
27 Replies

13. Shell Programming and Scripting

Controlling user input

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)
Discussion started by: darwin_886
10 Replies

14. Shell Programming and Scripting

[TIP] Processing YAML files with yq

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)
Discussion started by: stomp
1 Replies

15. What is on Your Mind?

Please Welcome Dave Munro to the Moderator Team!

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)
Discussion started by: Neo
6 Replies

Featured Tech Videos